please tell me the query to get details of the employee
having the second largest salary
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 |
Post New Answer View All Answers
Data table as parameter in sql server?
How to connect to SQL Azure Database by using sqlcmd?
How to include date and time values in sql statements?
What is the difference between Clustered and Non-Clustered Index?
Explain differentiate between a having clause and a where clause?
What is difference between drop truncate and delete?
What is an expensive query?
What are trace flags and mention a few common trace flags used with sql server?
How is table type constraint applied to a table?
What is the importance of a recovery model?
What command is used to rename the database?
How to get nth highest salary from employee table.
How to get the definition of a view out of the sql server?
What is a synonym for manipulation?
How to encrypt data between dialogs?