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

How to get nth highest salary from table in a mysql?

897

How many concurrent queries can mysql handle?

853

How to enable or disable a row of a table using MySQL in struts?

4035

How do I select a table in mysql?

860

Why is mysql popular?

831

Is mysql a programming language?

832

How do you select a table?

882

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

867

How do I delete a row in mysql?

888

How to create table with same structure of student table in mysql?

896

Describe mysql transaction properties.

959

What is a select query?

810

I want to find out all databases starting with ‘test’, I have access to?

1104

How do I find the database name in mysql?

893

Does mysql need a server?

855