what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 8576 Views
- I also Faced
- E-Mail Answers
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
Explain the concept of view and Types of views in SQL server?
What the class forname () does?
What are the lambda triggers?
What is the security model used in sql server 2005?
What are types of scd? : sql server analysis services, ssas
How to declare and use cursor variables?
What are the advantages of using third-party tools?
which table keeps the locking information? : Sql server administration
What are the types of dml?
What is a non-clustered index?
What are the 10 characteristics of data quality?
How dts is used to extract, transform and consolidate data?
What do you understand by a view? What does the with check option clause for a view do?
What is the difference between resultset and resultsetmetadata?
How does the report manager work in SSRS?
