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 is mysql default database?

934

What is the purpose of -> in the mysql terminal?

1059

Explain Access Control Lists.

951

What is ibdata1?

857

What are the technical specifications of mysql?

1107

What is different between sql and mysql?

966

Why mongodb is faster than mysql?

848

Is mysqli faster than mysql?

879

What is mysql sleep process?

970

How do I find users in mysql?

1041

What is save point in mysql?

918

What is the command used to create a database using php and mysql?

1101

How to create a table index in mysql?

916

What are the difference between now and current_date in mysql?

1339

What is the default port of mysql server?

988