select * from (select sal, rownum r from Employee order by sal desc) wher

find out the third highest salary?

Question Posted / chandiran

Answer Posted / chandiran

select * from (select sal, rownum r from Employee
order by sal desc)
where r=3

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the difference between pre-select and pre-query?

621

How to run create database statement?

573

Explain the use of grant option in exp command.

586

What is bulk load in oracle?

591

Explain oracle data types with examples?

575

What is meant by a deadlock situation?

576

How to fetch the row which has the max value for a column?

538

How to convert character types to numeric types?

574

How to initialize variables with default values?

634

What is the difference between online and offline backups?

560

What is merge statement used for?

567

How does one get the view definition of fixed views/tables?

597

What is PL/SQL ?

1111

How much memory your 10g xe server is using?

579

How to update a table row with a record?

597