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
What are indexers?
What authentication modes does sql server support?
What does executeupdate return?
Do you know the isolation level that sql server support?
What is stretch database in sql server?
how to overcome kernel isssues
What is an indexed view?
What it means to be triggered?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What is sql injection and why is it a problem? : sql server security
How to create a testing table with test data in ms sql server?
What is apply operator in sql?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
What is report server project?