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
- 72837 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / kapil singh chauhan
select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
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 dbms wizard?
What is #temp and @table variable in SQL server?
What is format parameter in ssrs?
What is the purpose of sql profiler in sql server?
What is the downside of using udf?
What is the difference between functions and stored procedures?
How do you delete duplicate rows in sql server?
Explain sub-query?
How much is a sql server license?
Can You Use Data Mining Models In Ssrs?
what is database replication? : Sql server database administration
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
how would you improve etl (extract, transform, load) throughput?
