SELECT DISTINCT(A.SAL),ENAME FROM EMP A WHERE &N=(SELECT COUNT(DISTINC

how to find nth highest salary

Question Posted / premsagar12

Answer Posted / premsagar12

SELECT DISTINCT(A.SAL),ENAME FROM EMP A WHERE &N=(SELECT
COUNT(DISTINCT(B.SAL )) FROM EMP B WHERE A.SAL<=B.SAL);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is efficiency data?

1004

What is a trace frag? Where do we use it?

1154

What is an active database?

1068

What are the different methods available under sqlcommand class to access the data?

1169

Is it possible to update the views? If yes, how, if not, why?

1085

How to use transact-sql statements to access the database engine?

1125

Do you know what is replace and stuff function in sql server?

1082

Can we take the full database backup in log shipping?

995

Does an index slow down updates on indexed columns?

1035

What is model database? : SQL Server Architecture

1192

What is conditional split?

1141

What are various aggregate functions that are available?

1041

What is the use of toad or sqldbx.?

1201

Is mysql the same as sql server?

1032

What is the difference between a function and a stored procedure?

1125