Write a query to get 2nd maximum salary in an employee table ?
Answer Posted / lalit raghuvanshi
I got the solution:
Multiple Sql server queries to get second,third,fourth or nth highest/maximum salary from employee table
http://www.webcodeexpert.com/2014/08/sql-server-query-to-get.html
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the use of <> sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
What is indexes?
What is gpt format?
Which is faster union or join?
What is dense_rank?
What is procedure and function?
Is sql difficult?
What are the basic sql commands?
What is the non-clustered index in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
What is output spooling in sql*plus?
what is the difference between inner and outer join? Explain with example. : Sql dba
Which is better join or subquery?
Does truncate require commit?