Number Of Page View:100,000+/Months
LOGIN |New User


What is the Sub-Query?And what is the properties of Sub-Query? 
Sub-queries are bassically defined as
sub-selects, Its allow a SELECT statement to be
executed arbitrarily within the body of another
SQL statement. A sub-query is mainly executed by
enclosing in a set of parenthesis. Sub-queries
are generally used to return a single row as an
atomic value, They may be used to comparision,
Its may be use for compare the values against
multiple rows with the IN-keyword. 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 resultset.
Meaning a subquery SELECT statement can stand
alone and is not depended on the statement in
which it is nested. A subquery SELECT statement
can return any number of values, and can be found
in, The column list of a SELECT statement,FROM,
GROUP BY,HAVING,and/or ORDER BY clauses of a
T-SQL statement. A Subquery can also be used as a
parameter to a function call. Basically a
subquery can be used anywhere an expression can
be used.