please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / richa
This is a general solution to nth level of salary
Select salary from (select salary from table order by salary
desc limit 3) tbl order by salary limit 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is oracle mysql free?
How do I run mysql without installing?
Is mysql free for enterprise?
What is the usage of "i-am-a-dummy" flag in mysql?
How do I add a column to a table in mysql?
What is the difference between heap table and temporary table?
How to find the unique values if the value in the column is repeated?
What is the difference between myisam dynamic and myisam static in mysql?
Does mysql case matter?
What is mysql default database?
What is triggers?
Where is the myisam table stored?
Where the database is stored in mysql?
What does innodb stand for?
Is mysql open source?