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

find out the third highest salary?

Question Posted / nagaraj a h

Answer Posted / nagaraj a h

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 ?

0 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Does facebook use oracle?

1031

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

1011

How to commit the current transaction in oracle?

1118

What are oracle functions?

1030

How will you identify oracle database software release?

1008

What is the simplest tool to run commands on oracle servers?

1007

What is a sub query and what are the different types of subqueries?

1123

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2270

Compare and contrast between sql and sql server and explain its various functions?

958

How a tablespace is related to data files?

1107

How many memory layers are in the oracle shared pool?

1179

What is an oracle and why it is used?

1147

What is oracle rowcount?

1084

What is transport network substrate (tns) in oracle?

1043

How to check the server version in oracle?

1092