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

What is the purpose of using a heap table?

1019

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

1258

What is auto increment in mysql?

911

Is null in mysql?

813

How to get a list of all tables in a database?

1002

using primary can we relate two table, with out foreign key?

2657

How to store binary data in mysql?

955

What is InnoDB?

1021

What is the difference between mysql and sql?

979

Is mysql connect deprecated?

912

How can we run batch mode in mysql?

990

what is the difference between between and in operators in mysql?

964

What are the advantages and disadvantages of using mysql?

933

What are the similarities between a function and a procedure?

825

How do I create a mysql database?

857