select distinct(a.sal) from emp a where 5=(select count(distinct(b.sal)) f

write a query for the fifth highest salary?

Question Posted / venkates

Answer Posted / venkates

select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)

Is This Answer Correct ?

22 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are different types of clusters present?

1075

What is the difference between primary and candidate key?

1124

What are the disadvantages of views in a database?

1052

What is the DIF format and when we will use in teradata

2488

Explain the field term used in database.

969

Is storing images in a database a good idea?

996

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1224

What is ole db provider for sql server?

1027

Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.

1133

What does specialization in DBMS mean?

1153

What is dialect in database?

971

What is the difference between database and server?

1018

How do you connect to a database?

1102

can we delete autodiff back up that we have set through sql server agent.

2197

What is the advantage of varchar2 over char?

1267