Answer / 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.

Answer / somu

2

How do I run sql server 2014?

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

How to delete database objects with "drop" statements in ms sql server?

0 Answers  

---

What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,

---

What is "scheduled jobs" or "scheduled tasks"?

0 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

0 Answers  

---

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

---

What is the synonym of join?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---