Answer / raju

Having clause is applied only to the group by function
where as where clause is applued to each and every row in a
table

Answer / dhiman

Where clause is used to check for the condition- select rows
& restrict rows and where comes before having clause whereas
Having is clause that is created to utilize all the group
functions (sum,avg,min,max,count) and is used for select or
restrict a particular group.

Answer / anil sharma

Having clause ia used only with group by, and where used with any input type

What is a sub-query? When would you use one?

3 Answers  

---

What are the differences between stored procedure and functions in SQL Server 2000?

25 Answers   College School Exams Tests, HCL, Infosys, TCS,

---

What is the function of sql server agent windows service?

0 Answers  

---

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

0 Answers  

---

what is diffrent between store procedure and trigger

2 Answers  

---

When cursors are useful?

0 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

Do you know what is user defined datatypes and when you should go for them?

0 Answers  

---

What is mssql?

0 Answers  

---

Can we take the full database backup in log shipping?

0 Answers  

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.

3 Answers   247Customer,

---