SELECT max( t1.col ) FROM `table` t1 WHERE t1.col

How to find out the second largest element from mysql table

Question Posted / salil

Answer Posted / salil

SELECT max( t1.col )
FROM `table` t1
WHERE t1.col < (SELECT max( t2.col ) FROM `table` t2);

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Is mysql written in c?

840

How can you count the total number of records of any table?

877

Where is the mysql database stored?

872

Which is better sqlite or mysql?

961

Is mysql good for large database?

862

How to enter microseconds in sql statements?

925

What is new mysqli?

862

What is the function of myisamchk?

913

How to check if value already exists in mysql database in php?

828

How to show table names with 'mysqlshow'?

960

What is sharding in mysql?

910

How can we change the data type of a column of a table?

940

How do you name a table?

835

Is mysql a free database?

892

What is difference between oracle sql and mysql?

954