find the 3rd max salary

Answer Posted / udaya

select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)

Is This Answer Correct ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by referential integrity?

593


While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?

89


What is the difference between varchar and nvarchar?

528


define and explain the differences between clustered and non-clustered indexes.

601


How to include date and time values in sql statements?

634






List out different types of normalizations in sql server and explain each of them?

559


What are the different editions available in sql server 2000?

590


Explain features of analysis services?

523


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1505


How do I find the transaction log size in sql server?

519


What is the use of =,==,=== operators?

581


Explain what is lock escalation?

579


sql database suspect We have a sql database that is showing as suspect. How can we recover?

1406


How to use linked server?

593


What is an indice?

577