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 the usage of "i-am-a-dummy" flag in mysql?

1060

Create table employee (eno int(2),ename varchar(10)) ?

945

What is required to create mysql database?

932

How do you insert a table?

873

What is memory table?

852

Can mysql scale horizontally?

925

How can you import tables from a sql file into a database by using the mysql client?

964

What is unsigned in mysql?

863

Is mysql a database?

877

How many types of indexes are there in mysql?

856

What is horizontally scalable?

923

What you can use regular expression for in mysql?

871

What is general log in mysql?

911

how to add a new column to an existing table?

935

How many TRIGGERS are allowed in MySql table?

1018