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
- 75065 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
Name and describe few console utilities for ssrs?
Where sql server usernames and passwords are stored in a sql server?
What is abstracting periodical?
What is index fragmentation in ms sql server?
What is a collation in ms sql server?
What are difference between Cluster index and Non-Cluster index?
What are the advantages of user-defined functions over stored procedures in sql server?
Can you explain important index characteristics?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Explain different backup plans?
Explain Geometry datatype in sql server 2008 with example
What are the 10 characteristics of data quality?
What is attribute hierarchy? : sql server analysis services, ssas
What is the difference between char, varchar and nvarchar?
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?
