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 is field in algebra?
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
What are the difference between primary key and unique key? : sql server database administration
How to delete duplicate records based on single column from a table?
What are the advantages of user-defined functions over stored procedures in sql server?
what type of index will get created after executing the above statement? : Sql server database administration
What are Row versions of DataRow?
Explain a differential backup?
How to integrate the ssrs reports in application?
Explain “row_number()” in sql server with an example?
How to execute a sql statement using odbc_exec()?
Explain DBCC?
Explain the microsoft sql server delete command?
How do you start single user mode in clustered installations?
Which is better statement or preparedstatement?
