write the query for find the top 2 highest salary in sql
server
Answer Posted / girish
select max(salary) from emp where sal<(select max(salary)
from emp
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can primary key be a foreign key?
What is enhanced database mirroring in sql server 2008?
What is the command dbcc checkdb used for?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
What are the options which must be set to allow the usage of optimistic models?
What are trace flags?
Explain cdc and sql injection?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to delete duplicate records based on single column from a table?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
How to use clusters?
Can you index views?
What is normalization of database?
Why are you getting errors when creating a new odbc dsn?
What is the order by used for?