adspace


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

Answer Posted / river

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

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is current version of mysql?

1081


What is the current mysql version?

1103


How to Change a users password from unix shell.

1221


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

1247