Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 9828 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
Explain how would you store your query in an SSRS report or a Database server?
Does group by or order by come first?
Explain trigger classes i.e. Instead of and after trigger?
Do you know what are acid properties?
Why do we use functions?
How to create a simple table to test triggers in ms sql server?
How to create a ddl trigger using "create trigger" statements?
What is a transaction and why is it important?
What is the purpose of the master database?
What is table value parameters (tvp)?
What is NOT NULL Constraint in sql server 2012?
Explain the truncate command?
What is cube dimension? : sql server analysis services, ssas
What are xml indexes?
What is always encrypted?
