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
- 12336 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil nair
SELECT EmpID,Salary from tblSalary a where 3=(select count
(distinct EmpID) from tblSalary b where b.empid>=a.empid)
For any database
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Explain user defined views?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
What is the sql case statement used for?
What is store procedure? How do they work?
Why does sql studio use a single registered database repository? : sql server management studio
What is the Difference Between Primary and Foreign Key?
What are “phantom rows”?
What command do we use to rename a database?
Can we install sql server 2016 on windows 7?
How real and float literal values are rounded?
How to create an inline table-valued function?
Can You Use Data Mining Models In Ssrs?
What is difference between clustered index and non clustered index?
What are the Advantages of using CTE in sql server?
How would you add a section to a table?
