select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
Answer Posted / vijay saxena
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 3 salary
FROM tblSalary
ORDER BY salary DESC)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Mention the differences between local and global temporary tables.
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is policy based management (pbm)? : sql server database administration
What are sub reports and how to create them?
Why the trigger fires multiple times in single login?
How do you create a data source?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How you can minimize the deadlock situation?
What are Spatial data types in SQL Server 2008
Explain differences between web edition and business edition?
What are ddl triggers and types of ddl trigger?
explain databases and sql server databases architecture? : Sql server database administration
Data table as parameter in sql server?
what kind of lan types do you know? : Sql server database administration
What is exporting and importing utility?