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

Is mysql same as mariadb?

944

In which language it is written?

1004

Is mysql free for enterprise?

949

What does blob mean in mysql?

1011

Where is mysql data stored?

934

How to calculate expressions with sql statements?

1164

How do I clear the command in mysql?

979

What are the 3 main types of search queries?

880

Is mysql a backend?

965

What is difference between mongodb and mysql?

971

How do you backup a database in mysql?

1116

What is general log in mysql?

1031

can you tell what are the different set operations available in mysql? : Mysql dba

939

How to get a list of columns in an existing table?

915

Is mysql better than oracle?

985