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 exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?

0 Answers  

---

How to bind a view to the schema of the underlying tables?

0 Answers  

---

What is the importance of concurrency control?

0 Answers  

---

Differencr Between DELETE and TRUNCATE?

3 Answers   ADP,

---

What is difference between views and stored procedures?

0 Answers  

---

How do you find the number of rows in a table?

7 Answers  

---

how do u do Performance tunning ?

1 Answers   Infodat Technologies, Satyam,

---

How to run queries with sql server management studio express?

0 Answers  

---

What are number line correlation administrators will use while working with a subquery?

0 Answers  

---

What is hot add cpu in sql server 2008?

0 Answers  

---