write the query for find the top 2 highest salary in sql
server
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 |
Post New Answer View All Answers
What does it mean to normalize a database and why would you do it?
What is the correct order of the logical query processing phases?
How important do you consider cursors or while loops for a transactional database?
How can we check the sql server version?
What is transact-sql language?
What is policy based management (pbm)? : sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is "scheduled jobs" or "scheduled tasks"?
How to replace null values in expressions using isnull()?
What is the difference between for trigger and after trigger?
List types of tables in SQL Azure?
Explain optimistic and pessimistic concurrency?
How many columns can we include on clustered index ?
How does recursive cte works in sql server?
What stored by the master?