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
What is procedures in mysql?
Write a program using the select statement, while loop.
How can you move the master database
What are the advantages of mysql?
What is mysqladmin flush hosts?
In mysql, what is joins? Explain
What are the different types of triggers in mysql?
write a query to mysql in safe mode and to change the root password
How do I create a stored procedure in mysql?
What is mysql aggregate functions? Explain
How can I see all mysql databases?
How to see the create table statement of an existing table?
What are the different column comparison operators in mysql?
What is pragma exception?
How to update a root password.