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

Answer Posted / prasun

SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 0,1

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you flush privileges?

523


In how many ways we can retrieve data in the result set of mysql using php?

608


how you will Create a database on the mysql server with unix shell.

550


What is clob datatype?

474


Do while loop in mysql procedure?

491






Is mysql case-sensitive?

486


What is max connection in mysql?

489


What is mysqli_result?

503


What is different between sql and mysql?

502


What port is mysql running on?

473


How can you validate emails using a single query?

452


What is database clustering in mysql?

473


What is a trigger? How you can create a trigger in mysql?

481


Where’s database data actually stored?

514


What are the applications required to support mysql?

479