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

Explain the types of exception?

1144

How to define a specific record type?

1084

How to invoke the data pump export utility?

1188

how the indexes are stored in the Oracle Database?

2271

What operating systems are supported by oracle database 10g xe?

1034

How to use values from other tables in update statements using oracle?

1080

What are the differences between char and varchar2 in oracle?

1172

What are the various types of snapshots ?

1029

How to do paging with oracle?

1000

How to define an anonymous procedure with variables?

1161

What is raw datatype in oracle?

1136

Give syntax for SQL and ORACLE joins.

1094

Give the various exception types.

993

Give the advantages and disadvantages of clusters.

1051

Explain about integrity constraint?

1125