Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 73045 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / ranjeet kumar shrivastava
select * from tbl_htl_cntry e where 2>=(select
count(distinct salary) from tbl_htl_cntry where
e.salary<=salary)
it is aslo working syntax.
ranjeetvasu@rediffmail.com
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
What is the difference between Normalization and De-normalization?
What is de-normalization in sql database administration? Give examples?
How to delete a database in ms sql server?
What is for xml in sql server?
Define self join in sql server joins?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
What is cached report?
What is the purpose of self join?
Would you store your query in a ssrs report or a database server? State the reason why?
Do you know what are the properties of the relational tables?
What is sql server transaction log file?
What is user-defined scalar function?
What are the differences between ms sql server & oracle?
How to resolve the orphan use problem? : sql server security
What are the extra roles available in msdb? : sql server security
