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

How can delete duplicate records in cte in sql server?

520


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3759


What are ddl triggers and types of ddl trigger?

608


List out what other servers you can use with ssrs?

93


Please illustrate physical database architecture? : SQL Server Architecture

534






What is the order in which the sql query is executed?

525


What is the syntax to execute the sys.dm_db_missing_index_details?

587


Explain contrast amongst grouped and non-bunched records?

519


Tell me extended events in sql server 2008?

562


How to modify the underlying query of an existing view?

539


Tell me about builtinadministrator?

562


How does index makes search faster?

604


What is merge join?

578


Differentiate sql server reporting services vs. Crystal reports?

150


what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration

539