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

Explain what are the different type of segments?

915

How to export your connection information to a file?

1076

What privilege is needed for a user to connect to oracle server?

942

What is a dynamic performance view in oracle?

949

Who developed oracle & when?

945

How to select all columns of all rows from a table in oracle?

993

What is tns service name?

1074

Explain the truncate in oracle?

914

How to rename an index in oracle?

1064

Is the After report trigger fired if the report execution fails ?

2879

How to call a sub procedure?

1036

Â How to use an oracle sequence generator in a mapping?

1021

Explain the use of record option in exp command.

949

How can Oracle users be audited?

1056

What is PL/SQL ?

1907