SELECT sal FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk FROM

How to find 1st, 2nd, 3rd highest using select select
statement not using rownum

Question Posted / madhavi

Answer Posted / madhavi

SELECT sal
FROM (SELECT sal, RANK() OVER(ORDER BY sal DESC) AS rnk
FROM emp)
WHERE rnk IN (1,2,3);

Is This Answer Correct ?

14 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Whether any commands are used for months calculation? If so, what are they?

1080

Can the query output be sorted by multiple columns in oracle?

969

What is bulk collect in oracle?

980

interview questions with answer for cts

2568

Can we convert a date to char in oracle and if so, what would be the syntax?

991

Explain drop constraint oracle?

1032

What are the oracle differences between nvl and coalesce

1126

Explain an integrity constrains?

1121

does the query needs a hint to access a materialized view?

1844

List the types of joins used in writing subqueries?

980

How to grant create session privilege to a user in oracle?

975

Differentiate between function and procedure in oracle.

1049

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1847

How to change system global area (sga) in oracle?

990

How will you identify oracle database software release?

983