THis is for Oracle SELECT * FROM emp (SELECT empname,Salary,dense

find out the third highest salary?

Question Posted / dilip tiwari

Answer Posted / dilip tiwari

THis is for Oracle

SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to call a sub procedure?

562

How do I recompile a procedure in oracle?

527

What are the differences between char and nchar in oracle?

595

How to write numeric literals in oracle?

610

What is Undo Management Advisor in Oracle?

609

How to call a stored function with parameters?

561

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

542

How are extents allocated to a segment?

575

What is a system tablespace?

598

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3823

How to use subqueries in the from clause in oracle?

579

Is rowid unique in oracle?

525

Can you have more than one content canvas view attached with a window ?

1815

How do I find the database name in oracle?

599

How to use "in" parameter properly?

617