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

Answer Posted / hamza tariq

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the non-standard sql commands supported by 'mysql'?

505


How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

567


What are mysql queries?

477


Can python connect to mysql?

477


What is a result set object?

518






What does the file with the extension: frm, myd, and myi contain?

467


What is the difference between heap table and temporary table?

609


Where’s database data actually stored? Is there a way to see the files which are stored?

499


How triggers can be used in mysql?

553


What is auto increment in mysql?

493


How to connect html form to mysql database using php?

479


How do I view tables in mysql workbench?

442


How do I change the max connection in mysql?

509


How can you handle the –secure-file-priv in mysql?

498


What is the default port for MySQL Server?

570