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

What is view in mysql?

926

Is mysql running ubuntu?

912

How will show all records containing the name "sonia" and the phone number '9876543210'

860

Can you tell a way to know the number of days between the two given dates in php?

1012

What is a scalar function?

930

How to represent ENUMs and SETs internally?

1085

What is the datatype for password in mysql?

924

How do I start mysql?

832

What is mysql community server?

871

What is blob in mysql?

952

How to use regular expression in pattern match conditions?

891

What is mysql in linux?

952

What is pdo :: fetch_assoc?

848

How do I clear a mysql database?

897

How do you rename a procedure in mysql?

894