SELECT * FROM `student` where class='Six' ORDER BY mark desc LIM

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

Question Posted / prasun

Answer Posted / prasun

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

Is This Answer Correct ?

1 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the current mysql version?

1103

What is current version of mysql?

1081

How to Change a users password from unix shell.

1221

Which statement is used in a select query for partial matching?

1247