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

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1950

What is the syntax for encrypting a column in SQL Server?

1124

What do you understand by the denormalisation?

963

Does order by actually change the order of the data in the tables or does it just change the output?

1150

What is spid in sql server profiler?

1112

Where do we use trace frag?

1022

What program is used to store the data source file?

965

You want to implement the many-to-many relationship while designing tables. How would you do it?

999

what are the core components of SSRS?

129

Define inner join? Explain with an example?

1002

How to insert multiple rows with a subquery?

1140

What is the difference between writing data to mirrored drives versus raid5 drives

935

What are the 2 types of classifications of constraints in the sql server?

1125

What is the use of stored procedure?

943

Can we perform backup restore operation on tempdb? : sql server database administration

1001