select sal from emp e where 2=(select count(distinct sal) from emp b where

find out the second highest salary?

Question Posted / subash

Answer Posted / subash

select sal from emp e
where 2=(select count(distinct sal) from emp b where
b.sal>e.sal)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is set operator oracle?

942

What is a trigger and what are its types?

1154

How to delete a column in an existing table?

1044

How to define a cusotmer as a supplier in ORACLE R12

2197

What is a lookup table in oracle?

955

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2237

How to define a procedure inside another procedure?

982

What would you do with an in-doubt distributed transaction?

1938

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

1150

How to rebuild an index in oracle?

990

What happens if recursive calls get out of control?

1033

What is oracle rowcount?

1051

What is a dynamic performance view in oracle?

959

What are the advantages of oracle 12c?

1143

How to loop through data rows in the implicit cursor?

1034