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

Explain what role entity and relationship play in an ER diagram.

1071

What is the difference between char and varchar2 datatype in sql?

1066

List the different index configurations possible for a table?

934

How to stop a loop early with break statements in ms sql server?

1020

What happens if null values are involved in arithmetic operations?

1011

What is a partition function in sql server?

1133

Explain how to use linked server?

991

How do I find query history in sql server?

942

Are null values the same as that of zero or a blank space?

1039

How do I run a trace in sql server?

983

Difference between report and query parameter. Why do we need different type of parameter?

953

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1991

Explain system functions or built-in functions? What are different types of system functions?

979

What is log shipping?

960

Do you know the isolation level that sql server support?

960