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 can I combine multiple rows into a comma-delimited list in oracle?

1058

How to resolve name conflicts between variables and columns?

1027

How to lock and unlock a user account in oracle?

1104

What is tns name?

980

What is the difference between view and materialized view in Oracle?

1149

What is a dynamic performance view in oracle?

989

How do we represent comments in oracle?

1046

How much memory your 10g xe server is using?

1103

How to Truncate Table in Oracle

1154

What are privileges and grants?

1065

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

1043

interview questions with answer for cts

2578

How do you store pictures in a database?

1002

material view and view disadvantages?

1070

How to synchronize 2 schema's objects?

2178