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 to get data from mysql in php?

425

What are date and time intervals?

509

What is the use of mysqli_connect in php?

467

How can I create database in mysql?

489

What is mysql57?

500

Is sqlite faster than mysql?

487

How to add a new column to an existing table in mysql?

522

How can you count the total number of records of any table?

501

What is 'mysqlimport'?

517

How to set mysql variable in php?

503

How to delete a database from mysql server.

512

Restore database (or database table) from backup.

552

What is truncate command?

447

How to create trigger in mysql phpmyadmin?

510

In which format data is stored in mysql database?

524