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
- 74009 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / saritha
select distinct top 2 salary from EMP order by salary desc
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define views.
Different types of keys in SQL?
What are the difference between clustered and a non-clustered index?
Difference between LEN() and DATALENGTH() in sql server ?
How to list all triggers in the database with sys.triggers in ms sql server?
What are the new features of sql server 2008 r2 reporting service?
how to define testing of network layers? : Sql server database administration
What do you mean by a dependent functionality in a build?
What is the difference between set and select?
What is blocking and how would you troubleshoot it? : sql server database administration
What is the sql case statement used for? Explain with an example?
Is oracle faster than sql server?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
