Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12639 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
Please explain go command in sql server?
What is the purpose of grouping data in a report?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
What is sql server 2000 work load governor?
What is function of CUBE ?
What is checkpoint in sql server?
What is analysis service repository?
Define Wed Edition in SQL Azure?
When columns are added to existing tables, what do they initially contain?
How many triggers you can have on a table?
Can I use sql azure as a backup with log shipping or database mirroring?
What are synonyms?
What are the aggregate and scalar functions?
What is database architecture? : SQL Server Architecture
How to get the definition of a user defined function back?
