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 show table names with 'mysqlshow'?

981

What does mysql flush tables do?

921

What is 'mysqlshow'?

1009

What is the difference between primary key and candidate key?

958

How large can a mysql table be?

908

What is the data type for image?

1016

What is the difference between char and varchar in mysql?

1037

How to enter Characters as HEX Numbers?

972

What does blob mean in mysql?

919

What is latest version of mysql?

960

Do you need a license for mysql?

909

How do I connect to a database in mysql workbench?

983

Can you tell how to find the number of rows in a resultset using php?

877

How can I compare two mysql databases?

920

How to load data files into tables with 'mysqlimport'?

945