write the query for find the top 2 highest salary in sql
server
Answer Posted / ranjeet kumar shrivastava
select * from tbl_htl_cntry e where 2>=(select
count(distinct salary) from tbl_htl_cntry where
e.salary<=salary)
it is aslo working syntax.
ranjeetvasu@rediffmail.com
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is the security principal at the server level that represents your session?
Is INSTEAD OF trigger directly applicable to Table ?
Do you know exporting and importing utility?
What is the difference between varchar and nvarchar datatypes?
Tell me what are the advantages of using stored procedures?
Explain what are the database objects? : SQL Server Architecture
What are the different types of data sources in ssrs?
What are the types of lock supported by ?
What is sql server agent and what are the two modes of authentication in sql server?
Differentiate between delete and truncate.
What is the difference between a function and a stored procedure?
How do I install only the client tools of sql server 2000?
Which tools are available to manage SQL Azure databases and servers?
Explain about link server in sql server?