select sal from emp where sal = (select sal from (select distinct sal

find out the third highest salary?

Question Posted / ruchira

Answer Posted / ruchira

select sal from emp
where sal =
(select sal from
(select distinct sal from emp OrderBy sal desc)
[table alias] where rownum < 4 )

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

WHAT IS ecc 6.0

1660

What is open database communication (odbc) in oracle?

546

What is oracle analytical function?

524

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605

What is a relational database management system?

674

Difference between pre-select and pre-query

575

How to save query output to a local file?

560

How does oracle handle read consistency?

676

Is there an oracle sql query that aggregates multiple rows into one row?

542

Can we protect our pl/sql source code?

572

What are the logical operations?

677

How to define a data field as not null?

631

What is the parameter mode that can be passed to a procedure?

570

Is the After report trigger fired if the report execution fails ?

2402

How do I use unicode codesets with the weblogic jdriver for oracle driver?

550