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
What are the purposes and advantages stored procedure?
What is the main purpose of having conversation group?
What is difference between count (*) and count column?
How many databases Microsoft SQL server provides?
What are the properties of the transaction?
how many triggers you can have on a table? : Sql server database administration
Explain four layers of abstraction microsoft architectured?
What are the source of constraints?
What are click through reports?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How you can change the database name in SQL SERVER?
Is foreign key unique?
What is transact-sql language?
What is the difference between for auto and for nested?
What is difference between views and stored procedures?
