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
- 73978 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / kapil singh chauhan
select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
What is the default value of an integer data type in sql server 2005?
How to stop log file growing too big?
What is hot add cpu in sql server 2008?
How to create a dml trigger using create trigger statements?
Does a full backup include transaction log?
Is port 1433 secure?
What is de-normalization in sql database administration? Give examples?
What is cte (common table expression)?
Explain different forms of normalization?
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is co-related sub query?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How many ways to create table-valued functions?
What are entities and relationships?
