write the query for find the top 2 highest salary in sql
server
Answer Posted / krishna
select * from emp e where 2>(select count(esal) from emp
where e.esal<=esal)
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
Explain tablesample?
What is purpose of normalization?
How is sql server used?
What are trace files?
Explain something about security and SQL Azure?
What are the different types of cursor?
What is scrollable cursor?
What is the maximum row of a size?
What are the differences between left join and inner join in sql server?
What are the features of Embedded SQL
How sql server executes a statement with nested subqueries?
what is a transaction? : Sql server database administration
What does the on delete cascade option do?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Explain atomicity?