What is the difference between WHERE clause and HAVING clause?

Technology Community › Category: SQL › What is the difference between WHERE clause and HAVING clause?
VietMX Staff asked 5 years ago
  • WHERE clause can only be applied on a static non-aggregated column
  • we will need to use HAVING for aggregated columns.