write the query for find the top 2 highest salary in sql
server
Answer Posted / santosh kumar
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
desc.
| Is This Answer Correct ? | 13 Yes | 14 No |
Post New Answer View All Answers
Why truncate is ddl?
Explain what is analysis service repository?
What is tablesample?
List out different types of normalizations in sql server and explain each of them?
What is the datatype of rowid?
Explain the commands in sql server?
What is precedence constraint?
We need to perform what steps in the following order to work with a cursor?
Explain various data region available in ssrs with their use?
What is the difference between index seek vs. Index scan?
What are trace flags and mention a few common trace flags used with sql server?
Will the writetext statement activate a trigger?
Do you know the policy based administration feature of sql server 2008?
What is ms sql server service broker?
Do you know sql server 2008 introduces automatic auditing?