Difference between where clause and having clause in sql server


We can user Where Clause with Select, insert, update and Delete statements
We can use Having clause only with Select statement.

We can’t use the   aggregate function  with Where Clause
We can use the aggregate function  with Having Clause
Where Clause we used to filter the particular row  not for groups
Having Clause used to filter groups
Difference between where clause and having clause in sql server Difference between where clause and having clause in sql server Reviewed by NEERAJ SRIVASTAVA on 6:26:00 PM Rating: 5

No comments:

Powered by Blogger.