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

find out the second highest salary?

Question Posted / sikindar

Answer Posted / sikindar

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

0 No

Please Help Members By Posting Answers For Below Questions

What are the original export and import utilities?

1261

Can multiple columns be used in group by in oracle?

1038

How many categories of data types?

1043

How to load excel data sheet to oracle database

1079

What are data pump export and import modes?

1112

Explain implicit cursor.

1075

what are archived logs?

2261

How do I call oracle stored procedures that take no parameters?

1206

Can we commit inside a function in oracle?

1014

What is save point in oracle database?

1366

What do you mean by redo log file mirroring?

1071

What are the differences between number and binary_float in oracle?

1149

When do we use group by clause in a sql query?

1101

What is an oracle database table?

1065

Is there a function to split a string in plsql?

1109