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

Find out the 3rd highest salary?

Question Posted / vikram kumar

Answer Posted / vikram kumar

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 difference between rank () row_number () and dense_rank () in sql?

1090

Why we use joins in sql?

965

What is the basic structure of an sql?

1079

What is the difference between inner join and left join?

972

When is the explicit cursor used ?

1012

In a distributed database system, can we execute two queries simultaneously?

1060

what is the difference between char_length and length? : Sql dba

1027

Differentiate between syntax and runtime errors.

1167

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2007

What is sql basics?

1029

Explain what is a field in a database and record in a database?

1073

explain normalization concept? : Sql dba

1031

How do I enable sql encryption?

1007

What is normalization in sql?

997

What is data control language (dcl)?

1114