select * from emp where &n=(select count(distinct(sal)) from emp b

find out the second highest salary?

Question Posted / nusrath sultana

Answer Posted / nusrath sultana

select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<=b.sal)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is data block in Oracle?

1149

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1922

Can we write insert statement in function in oracle?

1156

What are the data types in oracle?

1096

How to define a sub function?

1200

Is there an oracle sql query that aggregates multiple rows into one row?

1027

How to start a new transaction in oracle?

1136

what are bitmap indexes? How does they work?

2303

How will you differentiate between varchar & varchar2?

1086

How to execute a stored program unit?

1128

How to list all tables in your schema?

1117

How to shutdown your 10g xe server?

1205

What is a read only transaction in oracle?

1079

What are operators in oracle?

1102

What is an oracle data file?

1158