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

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

Give me any three differences between Truncate and Delete.

0 Answers   Genpact,

---

Is it possible to create trigger on views?

0 Answers  

---

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

---

What is a non-clustered index?

0 Answers  

---

What are the types of normalization?

0 Answers  

---

When should you use an instead of trigger?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

Which data type columns are the best candidates for full-text indexing?

0 Answers  

---

What is lock escalation and what is its purpose?

0 Answers  

---

What are a scheduled jobs or what is a scheduled tasks?

0 Answers  

---