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

Is mysql a scripting language?

906

What is a simple query?

913

What is insert query in mysql?

916

Can we store files in mysql?

922

What are the differences between char and varchar data types?

1113

How do I start mysql from command line?

1014

Can we store videos in mysql database?

953

How to use mysqldump to create a copy of the database?

1058

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1374

Should I use pdo or mysqli?

928

What is a csv table?

1011

What is mysql default database?

1009

How to enter boolean values in sql statements?

1135

What is a definer?

891

How to store binary data in mysql?

1006