SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT

how to find the n'th highest salary from emp ?

Question Posted / brajesh kumar

Answer Posted / brajesh kumar

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?

15 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to convert a string to a date in oracle database?

1093

IS it possible to built the oracle database without setting the kernal parameters?

2393

How remove data files before opening a database?

1133

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

1030

What happens if variable names collide with table/column names?

1263

Differentiate between pre-select and pre-query?

1153

How do I connect to oracle database?

1198

List out the difference between commit, rollback, and savepoint?

1092

State the various uses of dbcc command?

1104

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066

What is key preserved table?

1079

Point the difference between translate and replace?

1150

What is raw datatype in oracle?

1207

How do we represent comments in oracle?

1096

How view is different from a table?

1081