Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajkumar
As database developer, you must have ever written
subqueries in either SQL Server or any other database
platform. This article will describe shortly about types of
subquery.
A subquery is inner query that will be used by outer query.
A subquery could return scalar value or a series of value.
Based on query dependency, a subquery could be self-
contained or correlated one. A self-contained subquery is a
subquery independent from outer query, and correlated
subquery is a subquery that is referencing to a row in
outer query.
Self-contained subquery is easier to debug than correlated
subquery. And it is executed only once whereas correlated
subquery is executed once for each row of outer query.
Sample of self-contained subquery that returns scalar value
is shown below :
Select customerid
From dbo.orders
Where employeeid = (select employeeid from dbo.employees
where lastname = ‘RAJ’);
This query returns customers list whose employee is RAJ.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to insert a new row into a table with "insert into" statements in ms sql server?
What is subquery explain with example?
what is bit datatype? : Sql server database administration
How is a full-text index updated?
Define union, union all, minus, intersect?
What are click through reports?
What are entities and relationships?
What is the maximum rows in sql server table?
Will count(column) include columns with null values in its count?
Where can you add custom error messages to sql server?
Is sql server a database?
What is a periodical index?
How you can move data or databases between servers and databases in sql server?
How can I get data from a database on another server?
