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

how to find the second highest salary from emp table?

Question Posted / sankar sasmal

Answer Posted / sankar sasmal

select distinct sal from emp e where 2=(select count(distinct sal)from emp s where e.sal<=s.sal)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a string data type in sql?

956

How do I create an index in word?

965

What does trigger mean in slang?

998

What is auto increment feature in sql?

1063

How does cross join work?

874

Is foreign key mandatory?

938

What is microsoft t sql?

879

What are different sql data types?

951

How does postgresql compare to "nosql"?

980

List and explain the different types of join clauses supported in ansi-standard sql?

1296

What is a primary key? Explain

919

What is latest version of sql?

978

What is the difference between nested table and varray?

937

how many groups of data types? : Sql dba

970

What are the different schemas objects that can be created using pl/sql?

964