select * from emp where &n=(select count(distinct(sal)) from emp b

find out the second highest salary?

Question Posted / nusrath sultana

Answer Posted / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<=b.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain self joins in oracle?

1023

What is oracle server autotrace in oracle?

1166

What is a system tablespace and when it is created?

973

How to retrieve values from data fields in record variables?

1120

How to delete a column in an existing table?

1076

what is port in oracle? how is it related to database application.

1949

How many types of tables supported by oracle?

1079

What do you mean by a database transaction & what all tcl statements are available in oracle?

994

What are the numeric comparison operations?

1120

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1914

How to see the table columns used in an index?

1024

How to use attributes of the implicit cursor in oracle?

1011

How to rename a tablespace in oracle?

1087

How to pass parameters to procedures?

1035

How to create a new view in oracle?

1078