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

What are the advantages of mysql in comparison to oracle?

1066

how to connect a php script with the mysql database?

1119

What is timestamp in mysql?

1048

why not null is not allowed at table level

2807

What are the 'mysql' command line arguments?

1065

How do I change global variables in mysql?

946

What is save point in mysql?

1003

Is mysql a good database?

995

What is the current version of mysql?

1019

How do I disconnect mysql workbench?

1113

In which format data is stored in mysql database?

1049

What is difference between mysql and mysql workbench?

1019

How to find the unique values if the value in the column is repeated?

1042

Does mysql scale well?

944

How to delete a column and add a new column to database

994