Interested to Buy Any Domain ? << Click Here >> for more details...
please tell me the query to get details of the employee
having the second largest salary
- 11 Answers
- 14022 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 to generate create view script on an existing view?
What does ss stand for sexually?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
What are the High-Availability solutions in SQL Server and differentiate them briefly?
difference between Clustered index and non clustered index ?
How to create a ddl trigger using "create trigger" statements?
What is primary key index?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are the lambda triggers?
Write the syntax for stuff function in an sql server?
What is constraints and its types?
What is an indexed view?
How will you make an attribute not process? : sql server analysis services, ssas
What is difference between equi join and inner join?
What is the cartesian product of the table?
