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

Explain about integrity constraint?

1077

Write a syntax for update query in oracle?

968

How to start a new transaction in oracle?

1015

In which language oracle has been developed?

1014

What is blob datatype?

1052

What is the scope of a local variable?

995

Can you assign multiple query result rows to a variable?

931

How to define an explicit cursor in oracle?

985

How to delete an existing row from a table in oracle?

1014

What is tns service name?

1071

Can you drop an index associated with a unique or primary key constraint?

967

What are transaction isolation levels supported by oracle?

994

what is IDE,DMV in sql server?

2753

State the various uses of dbcc command?

988

Explain what are the uses of rollback segment?

960