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 port 3306 tcp or udp?

904

How to use like conditions?

964

How to write date and time literals?

1008

What is the default port number of mysql?

934

Is mysql owned by oracle?

995

What is mysql_connect?

930

How do I delete a row in mysql?

932

What is the use of mysqli_query?

870

What is truncate command?

924

How do you create a primary key?

990

Is mysql a relational database?

817

What is federated tables in mysql?

894

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

864

What are date and time data types in mysql?

1001

How to declare variable in mysql trigger?

988