please give me the answer for this:
query which generates the second highest integer in the table?
Answer Posted / vardhan rao
With Limit: nth highest salary
Select distinct(salary) from tablename order by salary desc
limit n-1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to delete a trigger in mysql?
What does "i_am_a_dummy flag" do in mysql?
What is mysql gpl?
What is mysql common?
How can you calculate the sum of any column of a table?
How to install mysql?
What is a transaction? Describe mysql transaction properties.
How to load data files into tables with 'mysqlimport'?
Is mysqli secure?
How can you make a database as your current database?
Why use stored procedures in mysql?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What are the security alerts while using mysql?
What is prepared statement in mysql?
Why mongodb is faster than mysql?