select * from emp where sal=(select a.sal from emp awhere 3=(select distinc

Find out the 3rd highest salary?

Question Posted / shibin k abraham

Answer Posted / shibin k abraham

select * from emp where sal=(select a.sal from emp awhere 3=(select distinct(count(b.sal)) from emp b where a.sal<=b.sal))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the best free sql database?

572

how can we find the number of rows in a table using mysql? : Sql dba

586

What programs use sql?

527

what are the differences between char and varchar? : Sql dba

529

What are triggers in sql?

583

What is the difference between cluster and non-cluster index?

620

Is it possible to update views?

542

What is cross join example?

556

How many types of primary keys are there?

529

What is the purpose of cursors in pl/sql?

636

What is the most restrictive isolation level? : Transact sql

557

Why is pl sql used?

527

What is the trigger in sql?

540

Show code of a cursor for loop.

584

What is sql in java?

545