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

What are various limitations of the views?

1090

Can you explain what is the use of custom fields in report?

1099

How to get a list of columns in a view using the "sp_columns" stored procedure?

1086

How do you drop an index?

973

Differentiate between SQL and ORACLE joins and write their syntax.

1073

What is a trigger and its types?

1039

What is the difference between createstatement and preparedstatement?

999

What are the types of table?

1031

wat wil hapn if we give the both read and deny read permission to user?

2151

Can we use max in where clause?

983

How many types of the database links?

1118

How to concatenate two strings in SQL Server.

1207

What are different type of Collation Sensitivity?

1048

What is equi join with example?

1230

Explain user defined views?

1009