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 / river

Answer Posted / river

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

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Write a query to find duplicate rows in table?

870

Is mysql a nosql database?

1061

What is procedure in mysql?

897

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

847

What are the different tables present in MySQL?

1064

How do I show all mysql databases?

934

What is bdb (berkeleydb)?

895

What is mysql procedure?

897

What is meant by decimal (5,2)?

978

How do I zip a file in mysql?

942

What command is used to delete the data from the table without deleting the table structure?

920

What is myisamchk?

916

How to create a new view in mysql?

882

How do I start and stop mysql on windows?

957

Can we create table in stored procedure?

918