select * from emp e1 where (3=(select count(distinct (e2.sal))from emp e2

find out the second highest salary?

Question Posted / padiya hiten

Answer Posted / padiya hiten

select * from emp e1 where (3=(select count(distinct
(e2.sal))from emp e2 where e2.sal>=e1.sal));

Is This Answer Correct ?

4 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is data type in oracle?

1043

Difference between pre-select and pre-query

1031

can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2996

Why do we use coalesce function in oracle?

1053

How to create a table index?

1063

How to shutdown your 10g xe server from command line?

1015

How to use fetch statement in a loop?

973

What is the recommended interval at which to run statspack snapshots, and why?

2860

How to get last row id?

941

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

1003

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2146

What is oracle rowcount?

1037

What is dynamic proxy?

963

What is the quickest way to export a table to a flat file?

920

How to set a transaction to be read only in oracle?

1033