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

How to get a list of columns using the "sys.columns" view in ms sql server?

920

What stored by the master? : sql server database administration

1030

How do you manipulate data?

850

What are difference between Cluster index and Non-Cluster index?

1022

Does windows server 2016 come with sql server?

881

Sql server reporting services vs. Crystal reports.

118

How do I create an extended event in sql server?

905

what are user defined datatypes and when you should go for them? : Sql server database administration

964

How can I create a new template for import ? : sql server management studio

1025

What is sql profiler. What are the default templates with it? : sql server database administration

953

What is the default port for SQL Server over a firewall?

1032

Are connections to sql server encrypted?

942

How secure is sql server database?

958

Explain what is dbcc?

964

Can a database be shrunk with users active?

1065