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

What is cursors? And what are the different types of cursor?

557


What is trace flag in sql server?

532


What is sql server english query?

547


What new changes are being made in SQL Server?

578


Explain can SSRS reports Cache results?

112






What is a raid and what are different types of raid configurations?

634


Find nth lowest salary or get nth lowest salary?

597


How to enable tcp/ip protocol on a sql server?

592


What are orphan records?

552


Explain the flow of creating a cube? : sql server analysis services, ssas

629


Explain differences between web edition and business edition?

103


What is BCNF? How is it better than 2NF & 3NF?

597


What are the different types of columns types constraints in the sql server?

529


What is the difference between deallocate cursor and close cursor?

728


Difference between aggregate functions of sql?

655