what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
Answer Posted / praveen singh
select min(salary) from salary where salary in(select top 3
salary from salary order by salary desc)
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
can a table be moved to different filegroup? : Sql server administration
What are parameterized reports? What are cascading parameters in ssrs reports?
What are the benefits of normalization?
What is a with(nolock)?
What is xml datatype?
Explain different backup plans?
What is index in an assignment?
What is merge join?
What is change data capture (cdc) feature?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Explain what is dbcc?
Explain how many types of relationship?
What is the largest component inside a field?
Does group by or order by come first?