what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
Answer Posted / sagar dhande
select top 2(salary) from (select top 3 (salary) from
dbo.employee order by salary desc)
order by salary
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is attribute hierarchy? : sql server analysis services, ssas
Explain the rules for designing files and file groups in sql server?
Tell me about joins in database system and explain each in detail.
How do I delete a sql server database?
What is trigger explain with program?
What happens if you delete a table that is used by a view?
What are the disadvantages of using querystrings to send data from one page to another?
How many columns can exist together per table?
Can you tell me about the concept of ER diagrams?
how you can move data or databases between servers and databases in sql server? : Sql server administration
Do you know what guidelines should be followed to help minimize deadlocks?
What is the difference between osql and query analyzer?
What is sql server database?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What do you understand by mirroring and mention the advantages of the mirroring?