Answer / bernatshaw

Sub-query means a Query within a Query.
This is the Example:
Select Employee_Id, Employee_name From Employees Where
Employee_Id IN (Select Mgr_Id from Manager)

Answer / rajendra

Sub query mean query within query ,but when you use sub
query on larg amount data that time it is not feasible

Answer / akhil

text and image datatypes are not allowed in
subqueries.Subqueries cannot manipulate their results
internally, that is, a subquery cannot include the order by
clause, the compute clause, or the into keyword.
Correlated (repeating) subqueries are not allowed in the
select clause of an updatable cursor defined by declare cursor.

Answer / amit kumar

A subquery is simply a SELECT query within a SELECT query.

example:-

SELECT City, Salary, (SELECT AVG(Salary) FROM Employee)
AS AvgSalary FROM Employee;

What protocol does sql server use?

1 Answers  

---

How to make a remote connection in a database?

1 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---

Explain the difference between control flow and data flow?

1 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

How do you set a trace flag in sql server?

1 Answers  

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1 Answers  

---

Do you know what are the steps to process a single select statement?

1 Answers  

---

What is a data source file?

1 Answers  

---

Tell me what is fill factor?

1 Answers  

---

Explain few examples of stored procedure over triggers?

1 Answers   ADITI,

---

How to recompile stored procedure at run time?

1 Answers  

---