DISPLAY THE RECORDS WHO'S GETTING 3RD HIGHEST SALARY. SELECT * FROM

how to find nth highest salary

Question Posted / sudhir

Answer Posted / sudhir

DISPLAY THE RECORDS WHO'S GETTING 3RD HIGHEST SALARY.

SELECT * FROM EMP E1
WHERE 3 =(SELECT COUNT(DISTINCT(SAL))
FROM EMP E2
WHERE E1.SAL <= E2.SAL)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do you trace the traffic hitting a sql server?

1072

What are the purposes and advantages stored procedure?

890

How many levels of sp nesting is possible?

999

How do you handle datasets larger than 50 gb?

162

What is a transaction and why is it important?

1003

What is multilevel indexing?

883

Describe in brief authentication modes in sql server.

968

What is dirty page?

921

What happens if you delete a table that is used by a view?

944

How to use union to merge outputs from two queries together in ms sql server?

1011

Would you store your query in a ssrs report or a database server? State the reason why?

148

Are resultset updatable?

896

What is the minimum recommended amount of ram for sql server 2012 enterprise?

890

How much does sql server 2016 cost?

989

What is lock escalation and what is its purpose?

922