write the query for find the top 2 highest salary in sql
server
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
How do I find the sql server database version?
What do you mean by 'normalization'?
Can one drop a column from a table?
ow to bring suspect mode datbase online from scratch
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
Difference between LEN() and DATALENGTH() in sql server ?
Can a function call a stored procedure in sql server?
Define candidate key, alternate key, and composite key.
What are the differences between local and global temporary tables?
How do you migrate data from mssql server to azure?
Why we need sql server?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What does COMMIT command do?
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?
How do you debug a procedure in sql server?