Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 10033 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil tiwari
select Top2(salery)from (select Top3 (salery) from tab1
order by salery DESC)order by salery.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Difference between Logical Page and Physical Page in SSRS.
How to see the event list of an existing trigger using sys.trigger_events?
Explain how many types of relationship?
How do clustered indexes store data?
how many type of indexing in database?
What is the default fill factor value?
What are parameterized reports?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What do you mean by an execution plan?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
explain different types of backups avaialabe in sql server? : Sql server database administration
In what version of sql server were synonyms released?
What is sql server profiler?
What is fill factor and pad index?
