please give me the answer for this:
query which generates the second highest integer in the table?
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 |
Post New Answer View All Answers
How to get data from mysql in php?
What are date and time intervals?
What is the use of mysqli_connect in php?
How can I create database in mysql?
What is mysql57?
Is sqlite faster than mysql?
How to add a new column to an existing table in mysql?
How can you count the total number of records of any table?
What is 'mysqlimport'?
How to set mysql variable in php?
How to delete a database from mysql server.
Restore database (or database table) from backup.
What is truncate command?
How to create trigger in mysql phpmyadmin?
In which format data is stored in mysql database?