write the query for find the top 2 highest salary in sql
server
Answer Posted / mohan c v
select min(salary) from
(select top 2 salary from emp order by salary desc) as a
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
how to avoid cursors? : Sql server database administration
How to provide login information for a new odbc dsn?
What is NOT NULL Constraint in sql server 2012?
How can we delete a table in sql server?
How to find the service pack installed? : sql server database administration
how to create a scrollable cursor with the scroll option? : Sql server database administration
What action plan is preferred if sql server is not responding?
Tell me what is the stuff and how does it differ from the replace function?
Define the one-to-one relationship while designing tables.
What sql server means?
What is the report builder?
Does sql server 2000 clustering support load balancing?
How to write an inner join with the where clause in ms sql server?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Why truncate is ddl?