write the query for find the top 2 highest salary in sql
server

Answer Posted / naren

select max(salary) as salary1 from employee where salary <
select max(salary) as salary2 from employee

Is This Answer Correct ?    27 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

662


What is user-defined inline table-valued function?

527


Can We Use Data-grids For Our Report In Ssrs?

149


After removing a table from database, what other related objects have to be dropped explicitly?

566


Does sql server 2016 have ssms?

530






what are the critical issues you have resloved in your company

1561


How to access the deleted record of an event?

589


What is the security principal at the database level that represents your session?

550


What are sql azure firewall rules?

85


What is the difference between dataadapter and datareader?

561


What type of locking occurs during the snapshot generation? : sql server replication

885


What are the steps to insert a table?

549


Define synonym?

735


Why we use the openxml clause?

553


What happens if ntwdblib.dll is missing on your machine?

648