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


Please Help Members By Posting Answers For Below Questions

What is difference between index seek vs. Index scan?

604


What happens if the update subquery returns multiple rows in ms sql server?

576


Can truncate be rolled back?

529


What is a ddl statement?

501


Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

530






What is reference section?

487


What is use of dbcc commands?

616


Explain filtered indexes?

541


What does it mean to invest in the index?

495


How to connect of datebase with sql express.?

614


What is difference between clustered and non clustered index?

514


What are different types of join?

750


can you instantiate a com object by using t-sql? : Sql server database administration

508


What is xml datatype?

638


what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?

5487