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

master table and child table performances and comparisons in Oracle ?

2138

What are the types of partitions in oracle?

1038

What is using clause and give example?

1050

What is an oracle tablespace?

1045

What is a directory object?

1099

Explain about the analyze command in oracle?

1055

What are the benefits of ordbms?

1088

Write a syntax for update query in oracle?

1036

What is connection pooling in oracle?

973

How to use group functions in the select clause using oracle?

1074

Explain view?

1039

What are the set operators union, union all, minus & intersect meant to do?

989

How to create a stored function in oracle?

1108

What privilege is needed for a user to query tables in another schema?

973

What is oracle join syntax?

1005