Answer / thirumal reddy

where clause used to impose conditions in any dml operation
ex:
selct * from emp where empid=10
having clause used to impose conditions on group data
ex:

select sum(sal),avg(sal),count(*) from emp
having avg(sal)>2000

Answer / sd

Where clause operates on the selection before the rows are
actually grouped.

Hence , Try to add as many condition as possible in where
clause instead of having to boost the SQL query performance.

Answer / vinay singh

We can't use Where clause with aggregate function and Having
clause always use with aggregate function.

**Vinay Singh

Answer / kundan ravi

having clause alwaye use with aggregate functions and where
clause use for conditions but not with aggregate functions.

What is clustered index

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

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

26 Answers   Eforce, Systematix,

---

explain different types of backups avaialabe in sql server? : Sql server database administration

0 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

What is Covering Indexes? Plz explain with example

3 Answers  

---

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

---

What is the tcp/ip port on which sql server runs?

0 Answers  

---

After using delete statement in sql query to delete some records...to retrieve the deleted records we can get using rollback command but till that where it stores means particular location name i need....(after deleting and rollback )

3 Answers   CarrizalSoft Technologies, iGate,

---

How is sql server used?

0 Answers  

---

What is the use of =,==,=== operators?

0 Answers  

---

What is a heap?

0 Answers  

---