Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 9650 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
How do I open port 1433?
What is the difference between a clustered index and a non-clustered index?
What is the difference between char, varchar and nvarchar?
How to check status of stored procedure in sql server?
Can you roll back the ddl statement in a trigger?
What is index, cluster index and nonclustered index?
What is precedence constraint?
How is sql server used?
Can You Use Data Mining Models In Ssrs?
What are a database and a data warehouse?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
What’s the distinction between dropping a info and taking a info offline?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are parameterized reports? What are cascading parameters in ssrs reports?
what are candidate key, alternate key and composite key? : Sql server database administration
