please give me the answer for this:
query which generates the second highest integer in the table?

Answer Posted / sunil kumar

select marks from tablename order by age desc limit 1,1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is delimiter in mysql trigger?

518


can you tell how can you display the maximum salary in sql? : Mysql dba

458


How to use mysqldump to create a copy of the database?

497


How to display top 10 rows in mysql?

574


What is limit in mysql?

437






What is auto increment in mysql?

493


How do I rename a table in mysql workbench?

492


Why mysql is used with php?

488


What is query log in mysql?

492


How do I change the max connections in mysql?

458


What is a result set object?

518


How to increment dates by 1 in mysql?

544


What is the default password for mysql?

452


How to see the create table statement of an existing table?

571


How would you get the current date in mysql?

646