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
Reviewed by NEERAJ SRIVASTAVA
on
6:26:00 PM
Rating:
No comments: