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 are the different types of normalization?

0 Answers  

---

What are examples of triggers?

0 Answers  

---

What is the full meaning of dml?

0 Answers  

---

What is catalog views?

0 Answers  

---

How to provide values to stored procedure parameters in ms sql server?

0 Answers  

---

What methods do you follow to protect from sql injection attack?

0 Answers  

---

What are the differences between char and varchar in ms sql server?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What is ms sql server service broker?

0 Answers  

---

Is foreign key a primary key?

0 Answers  

---

What is read uncmmited?

0 Answers  

---

as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration

0 Answers  

---