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
Explain what is the function of sql server agent windows service?
How to retrieve error messages using mssql_get_last_message()?
What will be the maximum number of indexes per table?
What is query cost in sql server?
What is an example of a foreign key?
What is normalization of database?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is read uncmmited?
What are some examples of schemas?
What is precedence constraint?
Determine when an index is appropriate?
How to create a new table in a given schema?
Why do we use functions?
Differentiate between a primary key and a unique key.
What is rtm version in sql server?