WHERE vs HAVING

by

Why is it that you need to place columns you create yourself (for example “select 1 as number”) after HAVING and not WHERE in MySQL?

WHERE is applied before GROUP BY, HAVING is applied after (and can filter on aggregates).

In general, you can reference aliases in neither of these clauses, but MySQL allows referencing SELECT level aliases in GROUP BY, ORDER BY and HAVING.

And are there any downsides instead of doing “WHERE 1” (writing the whole definition instead of a column name)

If your calculated expression does not contain any aggregates, putting it into the WHERE clause will most probably be more efficient.

More Related Contents:

  1. SELECTING with multiple WHERE conditions on same column
  2. Can you use an alias in the WHERE clause in mysql?
  3. Detect if value is number in MySQL
  4. MySQL Select last 7 days
  5. i have an error which i dont understand. can you help me? [closed]
  6. In SQL Server how to get the count of child if both parent and child are available [closed]
  7. Rank function in MySQL
  8. MySQL select 10 random rows from 600K rows fast
  9. Get a list of dates between two dates
  10. Calculate a running total in MySQL
  11. Calculate Age in MySQL (InnoDb)
  12. MySQL query String contains
  13. Best data type for storing currency values in a MySQL database
  14. Datetime equal or greater than today in MySQL
  15. How to get the next auto-increment id in mysql
  16. MySQL dynamic-pivot
  17. MySQL Workbench: How to keep the connection alive
  18. Can I reuse a calculated field in a SELECT query?
  19. Deleting duplicate rows from a table
  20. How create json format with group-concat mysql?
  21. MySQL INSERT INTO … VALUES and SELECT
  22. MySQL LIKE query with underscore
  23. Compare only day and month with date field in mysql
  24. What are practical differences between `REPLACE` and `INSERT … ON DUPLICATE KEY UPDATE` in MySQL?
  25. What is the difference between SQL and MySQL? [closed]
  26. how to use a like with a join in sql?
  27. INSERT INTO Table from multiple tables
  28. Execute INSERT if table is empty?
  29. Mysql How do you create a clustered index?
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment