select * from emp where &n-1=(select count(distinct(sal)) from emp b

find out the second highest salary?

Question Posted / v.karthikeyan

Answer Posted / v.karthikeyan

select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)

Is This Answer Correct ?

62 Yes

30 No

Please Help Members By Posting Answers For Below Questions

Why does Oracle not permit the use of PCTUSED with indexes?

2369

what happened to the global index when I truncate the data in one of the partition?

1964

What is a initialization parameter file in oracle?

989

What to do if the startbd.bat failed to start the xe instance?

1017

What is the difference between translate and replace in oracle?

1115

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

1943

Explain implicit cursor.

963

How can you merge two tables in oracle?

939

What is define in oracle?

999

Explain the truncate in oracle?

914

What is where clause in oracle?

982

How to start your 10g xe server from command line?

1001

What is SQL access advisor in Oracle?

1137

What happens if the update subquery returns multiple rows?

1046

How to establish administrator authentication to the server?

984