SELECT DISTINCT (a.sal) FROM EMP A WHERE 2 = (SELECT COUNT (DISTINCT (b.sa

find out the second highest salary?

Question Posted / sujeet sinha

Answer Posted / sujeet sinha

SELECT DISTINCT (a.sal) FROM EMP A WHERE 2 = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is oracle rowcount?

1090

Explain a segment?

1093

Explain the use of indexes option in imp command.

1183

definition of cluster and non-clustered index?

3035

what is insert all statement in sql

6526

What are the most common interview questions on ETL Testing for experience?

1145

How to write a left outer join with the where clause in oracle?

1086

How to pass a parameter to a cursor in oracle?

1186

Which is better Oracle or MS SQL? Why?

4953

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1153

Can we protect our pl/sql source code?

1049

How to delete a user account in oracle?

979

How do I uninstall oracle 11g?

1123

Can group functions be used in the order by clause in oracle?

999

is there a tool to trace queries, like profiler for sql server?

1144