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

Can the query output be sorted by multiple columns in oracle?

1060

What is redo log?

1113

Can we commit inside a function in oracle?

1013

What is truncate oracle?

1014

List the parts of a database trigger.

1108

How can you merge two tables in oracle?

1048

How to loop through data rows in the implicit cursor?

1120

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3019

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2872

What is sequence?

1136

What is oracle open database communication (odbc)?

1083

What is a cursor and what are the steps need to be taken?

1287

What is analyze command used for?

1124

How do you find current date and time in oracle?

1099

How to do paging with oracle?

1050