select top 1 * from ( select top 3 * from Student

How to find out the second largest element from mysql table

Question Posted / prashant chaudhary

Answer Posted / prashant chaudhary

select top 1 * from ( select top 3 * from Student_Info
order by marks desc)table1 order by marks

Is This Answer Correct ?

5 Yes

6 No

Please Help Members By Posting Answers For Below Questions

How to drop an existing table in mysql?

1062

How do I connect to a mysql database?

975

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

1433

How do I copy a table in mysql?

990

Where does mysql store data?

941

List data types in mysql? Explain

969

Explain the difference between mysql and mysql interfaces in php?

1164

What is mysql community server?

978

What is 1nf 2nf 3nf?

1036

What is difference between mysql and mysql server?

1038

What is append query?

962

What is a crosstab query?

1012

How is data stored in mysql?

976

What is unique key in mysql?

1050

How do I edit a database in mysql workbench?

952