write the query for find the top 2 highest salary in sql
server
Answer Posted / girish
select max(salary) from emp where sal<(select max(salary)
from emp
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is difference between index seek vs. Index scan?
What happens if the update subquery returns multiple rows in ms sql server?
Can truncate be rolled back?
What is a ddl statement?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
What is reference section?
What is use of dbcc commands?
Explain filtered indexes?
What does it mean to invest in the index?
How to connect of datebase with sql express.?
What is difference between clustered and non clustered index?
What are different types of join?
can you instantiate a com object by using t-sql? : Sql server database administration
What is xml datatype?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?