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
In which format does an image save in SQL Server database ?
How to name query output columns in ms sql server?
Is candidate a key?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are cursors and when they are useful?
What is amo? : sql server analysis services, ssas
What is explicit mode in sql server?
Does sql server use t sql?
What is the use of floor function in sql server?
Characterize join and name diverse sorts of joins?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
What are the different types of join?
What is nonclustered index on computed columns?
Scalability, Availability, Integration with internet, etc.)?
