write the query for find the top 2 highest salary in sql
server
Answer Posted / saravanan p
select distinct top 2 salary from employee order by salary
desc
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is database white box testing?
How do you drop an index?
What is 2nf normalization?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the purpose of the tempdb database?
tell me the disaster recovery plan
Why use triggers?
Describe different Processing Modes offered by SSRS?
How to select an exiting database using mssql_select_db()?
What do you understand by replication in sql server? Mention the different types of replication in sql server.
Do you know data definition language, data control language and data manipulation language?
What are the drawbacks of reporting in ssrs?
What is bit data type? What's the information that can be stored inside a bit column?
What is a system database and what is a user database?
What is the difference between char and varchar2 datatype in sql?