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
What is cursors? And what are the different types of cursor?
What is trace flag in sql server?
What is sql server english query?
What new changes are being made in SQL Server?
Explain can SSRS reports Cache results?
What is a raid and what are different types of raid configurations?
Find nth lowest salary or get nth lowest salary?
How to enable tcp/ip protocol on a sql server?
What are orphan records?
Explain the flow of creating a cube? : sql server analysis services, ssas
Explain differences between web edition and business edition?
What is BCNF? How is it better than 2NF & 3NF?
What are the different types of columns types constraints in the sql server?
What is the difference between deallocate cursor and close cursor?
Difference between aggregate functions of sql?