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 do I connect to a mysql database?
What is mysql vs sql?
Which statement is used in a select query for partial matching?
How you can create a trigger in mysql?
Which is better sqlite or mysql?
What does mysql flush privileges do?
Write a query to display current date and time?
What is key in mysql?
What is latest version of mysql?
Which is better mysql or mssql?
What is truncate in mysql?
What is append query?
What is ibdata1?
Is sql and mysql same?
What is mysql sleep process?