select empno,sal from (select empno,sal from emp order by sal desc) whe

Find out the 3rd highest salary?

Question Posted / shruti

Answer Posted / shruti

select empno,sal from
(select empno,sal from emp order by sal desc)
where rownum<4

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is pl sql code?

1006

What are records give examples?

974

What do you mean by query optimization?

961

What is the difference between the conventional and direct path loader? : aql loader

1133

What is sql partition?

1061

explain primary keys and auto increment fields in mysql : sql dba

912

What is count * in sql?

965

Is not equal in sql?

974

Explain isolation levels. : Transact sql

1027

What does (+) mean in sql joins?

1036

What is a relationship and what are they?

1088

Can we create table inside stored procedure?

925

List the various privileges that a user can grant to another user?

1011

What is clustered index sql?

960

What is the importance of sqlcode and sqlerrm?

1305