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

Is hive a database?

554

Under which circumstance should you create an index on a table?

684

Data structure used to implements a menu:

624

What advantages does DBMS have over traditional file systems?

589

Explain the table term used in database.

573

What does specialization in DBMS mean?

640

Explain transaction manager?

607

List various types of log-based recovery in DBMS.

568

Is redis in memory database?

534

What do you mean by database?

588

What is a sequence? Explain it with one example?

641

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

1733

Should I store images in database?

570

what is transaction state, buffer management, shadow paging

2924

What is dialect in database?

551