select top 2(salary) from (select top 3 (salary) from dbo.employee order b

what is syntex second or third highest salary.

thanks & Regards
Dhirendra sinha

Question Posted / sagar dhande

Answer Posted / sagar dhande

select top 2(salary) from (select top 3 (salary) from
dbo.employee order by salary desc)
order by salary

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many levels of sp nesting are possible?

1030

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

935

Tell me what is fill factor?

965

Do you know what are the steps to process a single select statement?

978

Is there any difference between primary key and unique with the not null condition?

956

How is SQL Azure different than SQL server?

225

What is the difference RDBMS and Graph Database?

1053

What is table level trigger?

1026

What are the different types of sql server replication? : sql server replication

1278

Do you know what is xpath?

1094

Can you edit the .rdl code associated with a linked report?

164

What are transactions in sql?

1069

How you can find out if an index is useful to the optimizer?

941

What is difference between count (*) and count 1?

933

What is the difference between inner join and equi join?

1004