Without using LIMIT SELECT max( t1.col ) FROM `table` t1 WHERE t1.col

please give me the answer for this:
query which generates the second highest integer in the table?

Question Posted / salil

Answer Posted / salil

Without using LIMIT

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I know if mysql is running on windows?

1070

State the differences between mongodb and mysql.

1172

What are the purposes of using enum and set data types?

931

What is the data source name for mysql?

946

How to delete a database from mysql server.

1056

How many ways to get the current time?

967

can you tell how can you display the maximum salary in sql? : Mysql dba

858

How to change a password for an existing user via mysqladmin?

977

What is mvcc in mysql?

993

What is different between sql and mysql?

1009

How do I know if mysql is installed on windows?

915

Where is the mysql database stored?

908

What is a definer?

868

What is bigint in mysql?

909

What is the limitation of mysql?

960