What is a sub-query? When would you use one?

Answer Posted / swapna

Subquery is used to get information from a table based on
unknown conditions.
If select stmt not perform entire task using
selection,projection,and joins then we can perform that
type of task using sub queries.

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

662


What is the new security features added in sql server 2014? : sql server security

630


What are sql server functions?

569


Does index slows down insert statements?

630


What is pessimistic concurrency?

603






What is implicit mode in sql server?

627


What is ms sql server service broker?

565


What is surrogate key? : sql server analysis services, ssas

740


What new changes are being made in SQL Server?

646


How can we delete Duplicate row in table?

694


What are sub reports?

160


Do you know what are the differences between lost updates and uncommitted dependencies?

614


Explain go command in sql server?

611


Is it possible to create trigger on views?

600


Describe different Processing Modes offered by SSRS?

187