select max(salary) as salary1 from employee where salary

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

Question Posted / naren

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

Please Help Members By Posting Answers For Below Questions

What does it mean to normalize a database and why would you do it?

977

What is the correct order of the logical query processing phases?

931

How important do you consider cursors or while loops for a transactional database?

960

How can we check the sql server version?

1055

What is transact-sql language?

1088

What is policy based management (pbm)? : sql server database administration

977

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1213

What is "scheduled jobs" or "scheduled tasks"?

973

How to replace null values in expressions using isnull()?

1098

What is the difference between for trigger and after trigger?

1101

List types of tables in SQL Azure?

126

Explain optimistic and pessimistic concurrency?

991

How many columns can we include on clustered index ?

983

How does recursive cte works in sql server?

1007

What stored by the master?

948