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;

How to get a list of columns in a view using "sys.columns" in ms sql server?

0 Answers  

---

How can you list all the table constraints in a database?

0 Answers  

---

What does man by sql wildcard characters in sql server?

0 Answers  

---

What are the transaction properties?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  

---

What is the difference between a local and a global temporary table?

0 Answers  

---

What is public role in sql server?

0 Answers  

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

what is bit data type? and what are the information that can be stored inside a bit column?

2 Answers  

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  

---