select * from emp m where(select count(distinct sal)+1 from emp s where s.s

How to get second highest salary from a table

Question Posted / srinivas

Answer Posted / srinivas

select * from emp m where(select count(distinct sal)+1 from emp s where s.sal>m.sal)=2

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What schema means?

877

What is sql catalog?

1000

How to add a column ‘salary’ to a table employee_details?

994

How do you drop a trigger?

967

What is a join query?

939

How many triggers can be applied on a table?

923

What is a common use of group by in sql?

1030

what are date and time intervals? : Sql dba

1034

How do I make my sql query run faster?

919

What is the difference between nested table and varray?

993

What is a scalar value in sql?

1054

How many indexes can be created on a table in sql?

1036

Is it possible to link two groups inside a cross products after the cross products group has been created?

993

What is data definition language?

1081

Is id a reserved word in sql?

1134