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 are the uses of linked server and explain it in detail?

1059

How to convert a date to char in oracle? Give one example.

1068

What are privileges and grants?

1066

Explain an index segment?

1118

How to select some columns from a table in oracle?

1091

How many types of synonyms in Oracle?

1121

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4585

Can sub procedure/function be called recursively?

1001

What is index in Oracle?

1072

How to do a full database export?

1107

How will you differentiate between varchar & varchar2?

1041

How can we force the database to use the user specified rollback segment?

1148

Explain constraining triggers.

1092

Why do we use bulk collect in oracle?

1058

What is BBED in Oracle?

1152