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

Can we use update in sql function?

599

What is pl sql record in oracle?

571

What is the meaning of disabling a trigger?

655

What does dml mean?

562

What is sqlerrd?

540

How do I count rows in sql query?

500

What is data control language?

539

How do I know if I have sql express or standard?

616

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2013

how to include character strings in sql statements? : Sql dba

566

How to return an array from java to pl/sql?

603

What is a recursive stored procedure?

625

What are sql constraints?

574

What is rowtype?

576

Explain what is table in a database?

593