write the query for find the top 2 highest salary in sql
server
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
User wants only to display only pdf as export option in report manager. How to achieve this?
Equi join and non equi join is possible with sql server?
What are parameterized reports? What are cascading parameters in ssrs reports?
How many levels of sp nesting are possible?
Distinguish between commit and rollback?
What is ddl command?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain what is the use of custom fields in report?
How to connect sql server management studio express to sql server 2005 express?
What do you think of this implementation? Can this be implemented better?
Explain how you can deploy an SSRS report?
How will you optimize a stored procedure optimization?
How to disable a login name in ms sql server?
What are types of storage modes? : sql server analysis services, ssas
Difference between drill down and drill through report.