select min(a.sal) from (select disctinct d.sal from emp d order by sal des

how to get second highest sal of emp table

Question Posted / amit bhagat

Answer Posted / amit bhagat

select min(a.sal) from (select disctinct d.sal from emp d
order by sal desc) a where rownum<=2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are oracle functions?

1092

Explain user account with reference to oracle.

1043

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

1235

What are the uses of Database Trigger ?

1802

What is the max number of columns in an oracle table?

1062

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2167

How to load data from external tables to regular tables?

1116

How to write a left outer join with the where clause in oracle?

1136

What are the varoius components of physical database structure of oracle database?

1054

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2558

How to connect to the server with user account: sys?

1066

What is clustered table in Oracle?

1271

What is rowid and rownum in oracle?

1078

Explain coalesce function?

1259

What are the execution control statements in oracle?

1142