select sal from employee e1 where 5 = (select count(*) from employee e2 wh

How to find 6th highest salary from Employee table ?

Question Posted / rahul gupta

Answer Posted / rahul gupta

select sal from employee e1 where 5 = (select count(*) from
employee e2 where e1.sal < e2.sal)

Is This Answer Correct ?

5 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is store procedure? How do they work?

1066

Can another user execute your local temporary stored procedures?

1023

what is a correlated sub-query? : Sql server database administration

987

How to list all login names on the ms sql server?

1178

How to delete duplicate rows from table except one?

1039

How to use old values to define new values in update statements in ms sql server?

1330

Do you know concepts and capabilities of sql server?

1106

What is difference between line feed ( ) and carriage return ( )?

947

What do you know about system database? : SQL Server Architecture

1033

How to find index size for each index on table?

1051

List types of tables in SQL Azure?

128

How to apply cascading referential integrity in place of triggers?

1087

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

1060

What are the differences between local and global temporary tables?

1124

Differentiate between a primary key and a unique key.

1111