Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 75091 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / krishna
select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)
| Is This Answer Correct ? | 8 Yes | 16 No |
Post New Answer View All Answers
What is wrong with sql server client libarary dll, ntwdblib.dll?
Define master database?
explain extended properties
How to copy data from one table to another table?
What are the difference between “where” and “having” clause in sql server?
How to divide query output into multiple groups with the group by clause in ms sql server?
Explain about extended stored procedure?
What is the difference between grant and with grant while giving permissions to the user?
What is command parameter in ssrs?
How to disable stored procedure sql server?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
Why use cursor in sql server?
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 a view and what are its advantages?
What are policy management terms?
