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 Return total number of rows.

1005

How to insert dynamic values in mysql using php?

1130

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

906

What is mysql default database?

989

What is the difference between mysql and oracle?

962

What is the difference between BLOB AND TEXT?

1141

how to add a new column to an existing table?

997

What is ddl, dml, and dcl?

978

explain GROUPBY & HAVING clause with examples.

2282

How do you login to MySql using Unix shell?

1163

What are the 5 r's of managing behaviors?

1077

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

878

What is the difference between char and varchar in mysql?

1102

Is foreign key indexed mysql?

884

How do I flush privileges in mysql?

1000