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

8 Answers
8967 Views
I also Faced
E-Mail Answers

Answer Posted / river

SELECT * FROM `student` where class='Six' ORDER BY mark desc
LIMIT 1,1

Is This Answer Correct ?

3 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can you tell the difference between ereg_replace() and eregi_replace()?

1029

Is mysql a framework?

918

What is mysqladmin flush hosts?

948

Is oracle mysql free?

866

How to enter microseconds in sql statements?

978

Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?

881

What is the insert?

873

Write a query to fetch common records between two tables using mysql?

1023

Is null in mysql?

866

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1383

What is mysql architecture?

1002

What is the default port of mysql server?

1026

What is a query in mysql?

987

Write a query to count the number of rows of a table in mysql.

929

What is a heap table?

953