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

Can we write pl sql mysql?

908

What are the technical specifications of mysql?

1109

1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

2452

How do I setup mysql?

864

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1299

What is select query in mysql?

879

Is mysql free for enterprise?

866

How to make a copy values from one column to another in mysql?

991

Explain the storage engines in mysql?

965

Is mysql written in c?

858

How do I stop a mysql command?

940

How do I copy a table in mysql workbench?

841

How do I start mysql server?

856

What does mysql_fetch_assoc do?

932

What is difference between pdo and mysqli?

935