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

Find out the 3rd highest salary?

Question Posted / himanshu

Answer Posted / himanshu

SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 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 the usage of nvl function?

1041

What is sql scripting?

1127

How many sql statements are used?

1018

Is left join and outer join same?

1076

What does rownum mean in sql?

1034

how to shut down the server with 'mysqladmin'? : Sql dba

1017

What is sqlcontext?

1090

What is informix sql?

985

How is data stored in sql?

1065

What are the query optimization techniques?

941

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

977

how to see the create table statement of an existing table? : Sql dba

1022

Why do we need sharding?

1001

Can we write ddl statements in functions?

1121

What does pl sql stand for?

1121