Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



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

Answer / mkd

A subquery is a SELECT statement that is nested within
another T-SQL statement. A subquery SELECT statement if
executed independently of the T-SQL statement, in which it
is nested, will return a result set. Meaning a subquery
SELECT statement can standalone and is not depended on the
statement in which it is nested.

Sometimes the criteria for determining which set of records
will be affected by a SELECT, UPDATE, DELETE and/or INSERT
statement cannot be obtained by hard coding the selection
criteria. Occasionally there is a need to use the results
of a SELECT statement to help determine which records are
returned or are affected by a T-SQL statement. When a
SELECT statement is used inside another statement, the
inside SELECT statement is known as a subquery.

Is This Answer Correct ?    13 Yes 0 No

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

Answer / c suresh kumar

sub query is part of main query.this useful we retrive data
from the another table.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

More SQL Server Interview Questions

plss anybody specify tha constrian management system in dbms

0 Answers   Police Constable,

What is a virtual table in sql?

0 Answers  

On a windows server 2003 active – passive failover cluster, how do you find the node which is active?

0 Answers  

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

What is the difference between the 2 operating modes of database mirroring?

0 Answers  

What is PROJECTION Operation?

0 Answers   Infosys,

How to delete a login name in ms sql server?

0 Answers  

How to list all user defined functions in the current database?

0 Answers  

how to take backup bcp out for a column in table in sql server?

0 Answers  

what is lazy writer?

1 Answers   Wipro,

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,

For more SQL Server Interview Questions Click Here
Categories