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;

Explain timestamp datatype?

0 Answers  

---

How do I find the transaction log size in sql server?

0 Answers  

---

What do you know about normalization and de- normalization?

0 Answers  

---

Distinguish between commit and rollback?

0 Answers  

---

What is the best way to move n number of DTS package from one SQLServer to another SQLServer?

1 Answers   RBS,

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

How to know the NAME of the Database and SIZE of the Database at the client node in Sql Server 2005

1 Answers  

---

What is difference between restoration and recovery in SQLServer?

3 Answers   Microsoft,

---

Differentiate between a having clause and a where clause.

0 Answers  

---