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 the current mysql version?

1105

Which statement is used in a select query for partial matching?

1247

What is current version of mysql?

1084

How to Change a users password from unix shell.

1223