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 can we find out the current date and time in oracle?

1132

What is partitioned table in Oracle?

1271

what are actual and formal parameters?

1160

How do I limit the number of rows returned by an oracle query after ordering?

1228

Explain view?

1089

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

1269

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3022

how may join possible between (requisition with purchase order)

2330

What are the uses of synonyms?

1187

What are a cluster and non-cluster index?

1065

Can the query output be sorted by multiple columns in oracle?

1061

what is the use of system.effective.date variable in oracle?

1163

What is the difference between hot backup and cold backup in oracle?

1078

How are extents allocated to a segment?

1182

What is ADDM Advisor in Oracle?

1226