Stats

666 Contributors: 12 Friday, September 30, 2016
Licensed under: CC-BY-SA
Not affiliated with Stack Overflow
Rip Tutorial: riptutorial@gmail.com
Roadmap: roadmap

Filter results using WHERE and HAVING

Syntax

  • SELECT column_name
    FROM table_name
    WHERE column_name operator value
  • SELECT column_name, aggregate_function(column_name)
    FROM table_name
    GROUP BY column_name
    HAVING aggregate_function(column_name) operator value

Related Examples