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

11. Display the client number and name and the client number and name of the person who referred that client.

2322

How view is different from a table?

1018

How to filter out duplications in the returning rows using oracle?

1006

IS it possible to built the oracle database without setting the kernal parameters?

2327

What is an oracle database?

1023

What is Data Dictionary Cache in Oracle?

1150

Will you be able to store pictures in the database?explain.

982

How different is ms access and oracle?

1021

What is a oracle database?

1038

Can we store pictures in the database and if so, how it can be done?

1020

Please explain oracle left join with an example?

1024

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

1059

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2949

What is oracle data type?

944

How many categories of data types?

977