select rownum as maxsal,sal from (select sal from emp order by sal desc)

find out the third highest salary?

Question Posted / mamta

92 Answers
150726 Views
CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
E-Mail Answers

Answer Posted / mamta

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

Is This Answer Correct ?

0 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is hash cluster in oracle?

1171

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2175

How do we get field detail of a table?

1077

What privilege is needed for a user to create indexes in oracle?

1026

How to find out what oracle odbc drivers are installed?

1040

Is primary key indexed by default in oracle?

987

Can we create database in oracle using command line ?

1085

How to start a new transaction in oracle?

1086

Is insert autocommit in oracle?

1066

what is the dual table in oracle?

990

What is backup in Oracle?

999

When do we use group by clause in a sql query?

1035

11. Display the client number and name and the client number and name of the person who referred that client.

2334

What is a trace file and how is it created in oracle?

1055

Differentiate between post-database commit and post-form commit?

1033