Hi everybody, This is one way to get the third highest salary select ROWN

find out the third highest salary?

Question Posted / naveen kumar

Answer Posted / naveen kumar

Hi everybody,
This is one way to get the third highest salary
select ROWNUM as RANK from (select * from emp order by sal)
where ROWNUM<=3

Is This Answer Correct ?

11 Yes

27 No

Please Help Members By Posting Answers For Below Questions

How to check database size in Oracle?

1191

What do you mean by a deadlock?

1065

What is an oracle?

1018

Explain the use of owner option in exp command.

1043

How to rename a column in an existing table?

1035

master table and child table performances and comparisons in Oracle ?

2138

What are the arithmetic operations?

1084

What is control file used for?

1209

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

1044

How to create an oracle testing table?

1069

How to start a new transaction in oracle?

1088

How to speed up webrick?

1076

Can we store images in oracle database?

1009

How to define a procedure inside another procedure?

1024

How to create lov dynamically at runtime & attach to text field?

1197