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
- 75183 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / santhosh kumar
select Distinct Top 2 Salary from EMP order by Salary desc
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
What is a result set object returned by mssql_query()?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What area unit the various kinds of info compression introduced in sql server 2008?
What is difference between index and primary key?
What does null mean?
Explain primary key, foreign key and unique key?
What’s the use of custom fields in report?
Can foreign key be duplicate?
How to view existing indexes on an given table using sys.indexes?
how you can configure a running aggregate in SSRS?
What to perform pattern match with the like operator?
What is instead of trigger sql server?
What are the transaction properties?
What is the most common type of join?
what are the Prerequisites for Replication?
