please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 12488 Views
- 247Customer, I also Faced
- E-Mail Answers
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
How can i Relate Tables in SSIS
what is a sub-report?
How to sort the query output with order by clauses in ms sql server?
Explain what are the authentication modes in sql server?
What are user-defined functions (udfs) in sql server?
What is difference between table aliases and column aliases? Do they affect performance?
What are the different authentication modes in sql server?
What is difference between sql and sql server?
How to access the deleted record of an event?
Explain the advantages of merge replication?
How to use subqueries with the exists operators in ms sql server?
Is there any difference between the primary key and unique key?
How dts is used to extract, transform and consolidate data?
How to run queries with sql server management studio express?
New concepts of sql server 2005 use in your project.
