SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP n salary FROM employee O

how to find the second highest salary from emp table?

Question Posted / ravi

Answer Posted / ravi

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

where n is the nth highest salary

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I trace sql profiler?

1043

Which is faster joins or subqueries?

1036

What is oracle pl sql developer?

1024

What is sql in java?

1134

Explain how to use transactions efficiently : transact sql

1017

What do you mean by table in sql?

1045

What are user defined functions?

1063

What is sql data?

1034

how can we repair a mysql table? : Sql dba

1041

what is the functionality of the function htmlentities? : Sql dba

1005

How do you use join?

993

What is the source code of a program?

1119

What are the different types of joins in sql?

1908

How to install oracle sql developer?

1096

What is sql not null constraint?

1093