Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the properties of the relational tables?
What is the chart in report?
What is the difference between lock, block and deadlock? : sql server database administration
What do you mean by recursive stored procedure?
What extended events?
Do you know sql server 2008 introduces automatic auditing?
What area unit the various kinds of info compression introduced in sql server 2008?
Explain how to send email from sql database?
How to find Duplicate Records In table?
Explain the functionalities that views support?
How to disable triggers using "disable trigger"?
What do you understand by recursive stored procedure?
What is primary key index?
How you can get the list of largest tables in a database?
How many types of schemas are there?
