select Distinct Top 2 Salary from EMP order by Salary desc

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

Question Posted / arun kumar k s

36 Answers
74004 Views
Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
E-Mail Answers

Answer Posted / arun kumar k s

select Distinct Top 2 Salary from EMP order by Salary desc

Is This Answer Correct ?

111 Yes

59 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I find the sql server database version?

1002

What do you mean by 'normalization'?

1056

Can one drop a column from a table?

1018

ow to bring suspect mode datbase online from scratch

1802

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1141

Difference between LEN() and DATALENGTH() in sql server ?

1101

Can a function call a stored procedure in sql server?

956

Define candidate key, alternate key, and composite key.

920

What are the differences between local and global temporary tables?

1078

How do you migrate data from mssql server to azure?

165

Why we need sql server?

958

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1077

What does COMMIT command do?

1058

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

190

How do you debug a procedure in sql server?

936