Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where

how to find the second highest salary from emp table?

Question Posted / jyotiprokash

Answer Posted / jyotiprokash

Select * from emp e1 where 1=(select count(distinct sal) from emp e2 where e1.salary<e2.salary)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to use boolean type in select statement?

997

What is sqlca in powerbuilder?

956

How do I create an index in word?

968

how to write date and time literals? : Sql dba

915

explain the difference between myisam static and myisam dynamic. : Sql dba

887

Can you rollback after commit?

936

What are the two parts of design view?

975

How to create a menu in sqlplus or pl/sql?

1065

What are the types of queries in sql?

1016

How can you save or place your msg in a table?

954

Explian rowid, rownum? What are the psoducolumns we have?

945

Explain isolation levels. : Transact sql

1017

What are pl/sql packages?

1035

How do I order by ascending in sql?

958

how to include numeric values in sql statements? : Sql dba

1041