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
- 73217 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
Answer Posted / shahid
select * from(select * from Employee order by salary desc) where rowNum<3
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How will you find out if there are expensive SQL statements running or not?
What is the datatype of rowid?
Explain following error properties?
How can you find out which stored procedures are recompiling?
How many types of schemas are there?
What is the purpose of self join?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What is index in an assignment?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What are different types of collation sensitivity?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
How to disconnect from a sql server using mssql_close()?
How to achieve Paging of records in SQL SERVER?
What are the difference between “where” and “having” clause in sql server?
How to turn off warning messages during php execution?
