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

find out the second highest salary?

Question Posted / v.karthikeyan

Answer Posted / v.karthikeyan

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

Is This Answer Correct ?

62 Yes

30 No

Please Help Members By Posting Answers For Below Questions

What are oracle functions?

1034

What to do if dba lost the system password?

1175

Can we write dml statement in function in oracle?

1088

Explain about your project and its relation to the current job position you are applying to?

1011

What is a table in oracle?

986

Can select statements be used on views in oracle?

1029

What is connection pooling in oracle?

975

How to count duplicated values in a column in oracle?

1050

What is oracle update statement with inner join ?

1066

State the various uses of dbcc command?

1061

What are the attributes of cursor?

1054

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

What is varray?

1146

What is a select query statement in oracle?

972

How to update values on multiple rows in oracle?

1036