please give me the answer for this:
query which generates the second highest integer in the table?
- 8 Answers
- 6821 Views
- I also Faced
- E-Mail Answers
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
Can a table have multiple primary keys?
Can we rename database in mysql?
Why do we write stored procedures?
change column name and make a unique column so we get no dupes.
What is the purpose of using ifnull() function?
What are aggregate functions in mysql?
How do I create a new database in mysql?
How do I connect to a database in mysql workbench?
What is view in mysql?
What are the differences between binary and varbinary?
How do I edit a trigger in mysql?
How do I install mysql on windows 10 64 bit?
How would you get the current date in mysql?
Is null in mysql?
How do I setup a mysql database?
