select sal from emp e where 2=(select count(distinct sal) from emp b where

find out the second highest salary?

Question Posted / subash

Answer Posted / subash

select sal from emp e
where 2=(select count(distinct sal) from emp b where
b.sal>e.sal)

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is archive log in Oracle?

1184

How to write numeric literals in oracle?

1238

How to use "for" statements in oracle?

1124

What are the components of logical database structure in oracle database?

1139

How index is implemented in oracle database?

1048

How remove data files before opening a database?

1135

How to connect to oracle using service name instead of sid?

1072

What is a oracle database?

1111

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1098

what are the advantages of running a database in archive log mode?

2258

how to clone 9i Database on to 10g Database.

2388

Explain the difference between a procedure and a function?

1241

How do I uninstall oracle client from windows?

1059

How to create an oracle database?

1104

Explain how are indexes update?

1123