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
- 14872 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
What is a subquery in a select query statement in ms sql server?
What is a performance monitor?
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 is partition, how will you implement it? : sql server analysis services, ssas
Can we use having clause without group by?
How to bind a view to the schema of the underlying tables?
What are scalar functions?
How to insert stored procedure result into temporary table?
What is TDS(Tabular Data Stream) Gateway?
What is indexing and its types?
How to get the query of a table in sql server?
What is clustered index
How to choose all records from the table?
Define master database?
What is primary key and example?
