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


Please Help Members By Posting Answers For Below Questions

can a table be moved to different filegroup? : Sql server administration

716


What are parameterized reports? What are cascading parameters in ssrs reports?

129


What are the benefits of normalization?

786


What is a with(nolock)?

753


What is xml datatype?

836






Explain different backup plans?

702


What is index in an assignment?

695


What is merge join?

811


What is change data capture (cdc) feature?

786


explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

695


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

772


Explain what is dbcc?

779


Explain how many types of relationship?

757


What is the largest component inside a field?

748


Does group by or order by come first?

713