select min(a.standardcost) from ( select distinct top 2 StandardCost f

please tell me the query to get details of the employee
having the second largest salary

Question Posted / sushil

Answer Posted / sushil

select min(a.standardcost) from
(
select distinct top 2 StandardCost
from Production.ProductCostHistory
order by standardcost desc
)a

Is This Answer Correct ?

5 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between varchar and nvarchar?

950

What are the different SQL Server Versions you have worked on?

1015

What is difference between getdate and sysdatetime in sql server 2008?

1059

Does sql server 2016 have ssms?

969

What is stored in the mssqlsystemresource database? : sql server database administration

1041

What are cursors in ms sql server?

1190

What is the default server name for sql server?

1186

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

987

What is use of dbcc commands?

1082

what type of index will get created after executing the above statement? : Sql server database administration

978

What is a db view?

910

Write the syntax for stuff function in an sql server?

1036

What is inner join? Explain with an example?

1235

What are the types of stored procedures in an sql server?

1000

What is database black box testing?

1040