What is the difference between WHERE clause and HAVING clause?

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