Domanda di colloquio di Bookspan

Difference between Where and Having in sql?

Risposta di colloquio

Anonimo

5 mar 2015

Both filters out records based on one or more conditions. The diff is "where" can only be applied on static non aggregated column whereas having is for aggregated columns.