Posts Tagged ‘having clause’

Differences between where and having clause

WHERE: Where clause is used to filter the data based on condition. Only rows that meets conditions contribute data to the result set. Filters rows Where clause is executed before group by clause. Use where clause, if there is no aggregate function in condition.

Powered by k2schools