please tell me the query to get details of the employee
having the second largest salary
Answer Posted / ajay sara
Select Min(Salary) From (Select Top N * From Table_Name
Order by Salary Desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write the syntax for stuff function in an sql server?
Can you use order by when defining a view?
Mention a few common trace flags used with sql server?
What is SQL Server?
What do you understand by coalesce in sql server?
Is it possible in sql table to have more than one foreign key?
What is schemabinding a view?
Can we check locks in database? If so, how can we do this lock check?
Write a sql query to delete duplicate records from a table called table1
what method you can use to reduce the overhead of Reporting Services data sources?
How will you make an attribute not process? : sql server analysis services, ssas
What is 2nf normalization?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
What is the difference between a clustered index and a non-clustered index?
Is foreign key unique?