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

How to fetch alternate records from a table?

1162

what are sequences

1627

what tools available for managing mysql server? : Sql dba

1015

What is materialized view. What are different methods of refresh?

1336

what are the features and advantages of object-oriented programming? : Sql dba

955

What is cursor status?

1137

How can you load microsoft excel data into oracle? : aql loader

1130

explain normalization concept? : Sql dba

998

What are the features of pl sql?

1015

Is foreign key mandatory?

944

How does postgresql compare to mysql?

989

What is difference between inner join and self join?

1031

Which version of sql do I have?

1000

Explain the purpose of %type and %rowtype data types with the example?

929

What is cross join sql?

868