How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / yogesh
A little correction:
sol2> select salary from emp order by salary desc limit 1,1;
select salary from emp order by salary desc limit n-1,1;
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are rows and columns?
Do you know the cursor optimization tips?
What is sharding?
Would you store your query in a ssrs report or a database server? State the reason why?
Explain iaas, paas and saas?
What is the architecture of ms sql reporting service?
What is a transaction and why is it important?
What is sql injection? How to protect against sql injection attack?
How to throw custom exception in Stored Procedure?
Please explain go command in sql server?
How can a database be repaired?
How to convert numeric expression data types using the cast() function?
What is the difference between stored procedure and user defined functions?
What are page splits? : SQL Server Architecture
How to manipulate data from one table to another table ?