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.
- 8 Answers
- 11412 Views
- TCS, I also Faced
- E-Mail Answers
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
Do you know what is fill factor and pad index?
What is difference statement and preparedstatement?
How to test subquery results with the exists operator?
What is query and its types?
Is truncate autocommit?
What are rows and columns?
How do you implement session management in SQL Server mode?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How to sort query output in descending order in ms sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
Explain about Joins?
What are the types of joins in sql?
What is trigger and different types of Triggers?
What is difference between global temporary tables and local temporary tables?
Explain about sql server login?
