1). Where clause filters the rows before grouping i.e. aggregation is performed,where as Having clause does after the grouping is performed.
2). Where clause can be used with insert,update and delete statement,where as having clause is only used with select statement.
3). Aggregate function can not be used in the Where clause,where as in the Having clause we can use aggregate function.
Asked In: Many Interviews |