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
- 74176 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / nilesh
select * from employee2 e where 2=(select count(distinct salary) from employee2
where e.salary<=salary)
Its working.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Sql server reporting services vs. Crystal reports.
Explain the architecture of ms sql reporting service?
Why are you getting errors when creating a new odbc dsn?
How to stop log file growing too big?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is best institute to Learn DotNET And SQL in chennai?
Why I am getting this error when renaming a database in ms sql server?
Explain different forms of normalization?
What is hot add cpu in sql server 2008?
What command is used to delete a table from the database in the sql server and how?
What does it mean to invest in the index?
How many types of stored procedures are there in sql server?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
What is right outer join in sql server joins?
