Interested to Buy Any Domain ? << Click Here >> for more details...
please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 8709 Views
- I also Faced
- E-Mail Answers
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
What is difference between function and procedure in mysql?
Does insert statement lock the table?
Write command to import an mysql file?
Where is the mysql config file?
How many rows can be inserted in mysql at a time?
Where is mysql data stored linux?
What port is mysql running on?
State the differences between mongodb and mysql.
How do you create a schema?
What is delimiter $$?
How do you create a table in mysql workbench?
What is new mysqli?
How do I setup mysql?
How to drop an existing index in mysql?
What is slow query log in mysql?
