Select Top1 salary from(select Distinct Top2 salary from employee order by

how to find the second highest salary from emp table?

Question Posted / satish kumar

Answer Posted / satish kumar

Select Top1 salary
from(select Distinct Top2 salary from employee order by salary DESC) a order by salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is indexes?

1119

Does truncate remove indexes?

1084

What is the purpose of design view?

1078

Where the sql database files are stored?

1081

How to test for null values?

1098

How many columns should be in an index?

1016

What is rank function in sql?

1072

Can we use loop in sql?

1011

What is scalar function in sql?

1100

how do you know the version of your mysql server? : Sql dba

1048

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

Is pl sql better than sql?

1089

What is coalesce sql?

1056

Can dml statements be used in pl/sql?

1126

Name some usages of database trigger?

1087