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

How to drop a stored procedure in oracle?

1102

What are the differences between blob and clob in oracle?

1133

How to name query output columns in oracle?

1237

What is the difference between alert log file and tarce file ?

2223

What is oracle open database communication (odbc)?

1082

How to start your 10g xe server?

1087

Explain the dml?

1041

What do you understand by a database object? Can you list a few of them?

1062

How does one get the view definition of fixed views/tables?

1069

What is the difference between "as" and "is" in an oracle stored procedure?

1046

How to assign a table row to a record variable?

1089

What are the ansi data types supported in oracle?

986

How many types of tables supported by oracle?

1118

What is varray?

1192

Explain do view contain data?

1047