select min(a.sal) from (select disctinct d.sal from emp d order by sal des

how to get second highest sal of emp table

Question Posted / amit bhagat

Answer Posted / amit bhagat

select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the use of file option in exp command.

1106

How to create a server parameter file?

1099

What are the differences between primary key and unique key?

964

What are internal user account in oracle?

962

What is connection pool in oracle?

947

How do I uninstall oracle client from windows?

983

How to drop an index?

926

How to assign data of the deleted row to variables?

1030

What is a sub query? What are its various types?

1112

How do I reset a sequence in oracle?

1069

What is the relation of a user account and a schema in oracle?

1037

what is insert all statement in sql

6430

How do I spool in oracle?

963

What are set operators?

1047

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2095