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 database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration

534


What is sleeping status in sql server?

526


What is query optimizer in sql server?

553


List the different normalization forms?

546


How to update muliple row in single query?

613






What is meant by indexing files?

584


How to create a testing table with test data in ms sql server?

562


Explain some stored procedure creating best practices or guidelines?

527


Explain what is the use of custom fields in report?

501


Why use “nolock” in sql server?

565


How to install sql server 2005 express edition?

597


role of sql sever 2005 in database rather than any other database

1514


What happens if null values are involved in datetime operations?

539


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

542


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1989