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

What are the attributes of the cursor?

1007

Is oracle an open source?

1084

What is ceil and floor in oracle?

1076

What is oracle thin client?

1029

what is difference between sql plus and sql*plus? (not sql and sql plus).

3909

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

does the query needs a hint to access a materialized view?

1867

What is dual table oracle?

995

What is merge in oracle?

1062

What is the difference between substr & instr functions?

1236

How to get execution statistics reports on query statements?

1105

How to define an anonymous procedure with variables?

1167

How a tablespace is related to data files?

1112

What is a private synonym?

1593

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

1020