What are sub-queries? Give example? In which case
sub-queries are not feasible?

Answer Posted / rajendra

Sub query mean query within query ,but when you use sub
query on larg amount data that time it is not feasible

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between view and materialized view?

720


What is named calculation? : sql server analysis services, ssas

749


What is fill factor and pad index?

761


Explain boyce and codd normal form(bcnf)?

713


Mention the differences between local and global temporary tables.

756


Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

701


What is GUID in sql server?

838


What is a bit datatype?

750


What are the new features of sql server 2012 reporting service?

101


Please differentiate between a local and a global temporary table?

766


List some of the rules that apply to creating and using a ‘view’

681


What are the properties of primary key?

731


what are different types of raid configurations? : Sql server database administration

720


What is the security principal at the server level that represents your session?

796


how many clustered indexes can be created on a table? : Sql server database administration

790