how to find nth highest salary

Answer Posted / chandra sekhar

select min(salary) from emp where salary in (select top n salary from emp order by salary desc)

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name the different type of indexes in sql?

635


Show Practically Sql Server Views are updatable?

698


what is memory-optimized nonclustered indexes

650


How can we delete a table in sql server?

635


What is normalization process?

686






What is the full form of dql?

614


What is cube dimension? : sql server analysis services, ssas

600


Explain about builtinadministrator?

678


Does index speed up select statements?

668


What is query processing?

623


What is abstracting periodical?

607


What is the cartesian product of table?

631


Explain features of analysis services?

605


How to invoke a trigger on demand?

636


How to add an address record into adventureworkslt?

660