Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 10031 Views
- I also Faced
- E-Mail Answers
Answer Posted / vikas kant
---To get 2nd highest salary----
select Top 1 salary from Emp where marks in(select top 2
salary from Emp order by salary desc)
---To get 3rd highest salary----
select Top 1 salary from Emp where marks in(select top 3
salary from Emp order by salary desc)
Regards Vikas Kant
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is filtered index?
how would you troubleshoot blocking? : Sql server database administration
What is the difference between char, varchar and nvarchar?
What is difference between join and natural join?
How to insert multiple rows with a subquery?
why would you use sql agent? : Sql server database administration
What are the types of ssrs?
Is it safe to delete log files?
How to find the version of sql server? : sql server database administration
What are data driven subscriptions?
A trigger can reference objects outside the current database? State true or false.
What Are the Main Features of SQL Azure?
What is normalization process?
What is SQL Azure?
Explain multiserver query
