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


Please Help Members By Posting Answers For Below Questions

What is the use of <> sql?

556


how to dump a table to a file with 'mysqldump'? : Sql dba

555


What is indexes?

548


What is gpt format?

509


Which is faster union or join?

495






What is dense_rank?

540


What is procedure and function?

520


Is sql difficult?

748


What are the basic sql commands?

550


What is the non-clustered index in sql?

591


How to find 3rd highest salary of an employee from the employee table in sql?

571


What is output spooling in sql*plus?

557


what is the difference between inner and outer join? Explain with example. : Sql dba

553


Which is better join or subquery?

608


Does truncate require commit?

547