select a.sal from emp a where 2=(select count(distinct(b.sal)) from emp b w

how to find the second highest salary from emp table?

Question Posted / r.arjunarao

Answer Posted / r.arjunarao

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are commit, rollback, and savepoint?

990

The select into statement is most often used to create backup copies of tables or for archiving records?

1064

What information is needed to connect sql*plus an oracle server?

1026

what does myisamchk do? : Sql dba

1012

What is the difference between the conventional and direct path loader? : aql loader

1152

What is Collation Sensitivity ? What are the various type ?

952

how can we know the number of days between two given dates using mysql? : Sql dba

1046

How to start the command-line sql*plus?

1051

What are packages in pl sql and also explain its advantages?

1035

What are the features of pl sql?

1065

how to select unique records from a table? : Sql dba

1111

Are left and right joins the same?

1081

Explain the difference between triggers and constraints?

969

What is sql and db2?

997

What is sql comments?

1072