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

find out the third highest salary?

Question Posted / sapna rawal

Answer Posted / sapna rawal

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

n=3.In this case.

Is This Answer Correct ?

1 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How to use subqueries with the exists operator in oracle?

972

What are joins, explain all types of joins?

2221

how to handle exceptions in post production

1362

What is the database name in oracle?

972

How to use subqueries in the from clause in oracle?

1046

How to define an anonymous procedure with variables?

1065

How to define an anonymous block?

1075

is there a tool to trace queries, like profiler for sql server?

1078

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1957

What is sharded cluster?

926

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1060

Explain what are the different type of segments?

915

What happens if the update subquery returns multiple rows?

1046

What are the uses of linked server and explain it in detail?

1004

What is different types of joins?

969