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

What is pdo :: fetch_assoc?

904

Can we use mysql and mysqli together?

989

How do I know if mysql is running on windows?

1090

What do ddl, dml, and dcl stand for?

915

How do you select a table?

953

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

884

What is ibdata1?

909

What is view in mysql?

972

What is the use of mysqli_fetch_array?

1047

What is mysql command line?

1056

How do I flush privileges in mysql?

1004

How do I rename a procedure?

882

How to create trigger in mysql workbench?

996

What is a delimiter in mysql?

1029

How to enter numeric values as hex numbers?

972