Why can’t I use an alias for an aggregate in a having clause?

by

The HAVING clause is evaluated before the SELECT – so the server doesn’t yet know about that alias.

  1. First, the product of all tables in the FROM clause is formed.

  2. The WHERE clause is then evaluated to eliminate rows that do not satisfy the search_condition.

  3. Next, the rows are grouped using the columns in the GROUP BY clause.

  4. Then, groups that do not satisfy the search_condition in the HAVING clause are eliminated.

  5. Next, the expressions in the SELECT statement target list are evaluated.

  6. If the DISTINCT keyword in present in the select clause, duplicate rows are now eliminated.

  7. The UNION is taken after each sub-select is evaluated.

  8. Finally, the resulting rows are sorted according to the columns specified in the ORDER BY clause.

  9. TOP clause is executed.

Hope this answers your question. Also, it explains why the alias works in ORDER BY clause.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. How to create a table from select query result in SQL Server 2008 [duplicate]
  4. How to create composite primary key in SQL Server 2008
  5. Parse comma-separated string to make IN List of strings in the Where clause
  6. OPTION (RECOMPILE) is Always Faster; Why?
  7. sql runs fast in ssms slow in asp.net
  8. Sub queries in check constraint
  9. Rename column SQL Server 2008
  10. How do I use structural annotations to set SQL type to Date in model first approach
  11. Sql Server deterministic user-defined function
  12. Split function in SQL Server 2008
  13. Remove numbers from string sql server
  14. How to enable Ad Hoc Distributed Queries
  15. How do I edit a table in order to enable CASCADE DELETE?
  16. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  17. SQL Server SELECT LAST N Rows
  18. WHERE Clause to find all records in a specific month
  19. How can I group by date time column without taking time into consideration
  20. The transaction log for the database is full
  21. Using a database table as a queue
  22. When using GETDATE() in many places, is it better to use a variable?
  23. How do I change db schema to dbo
  24. Count records for every month in a year
  25. How to export data from Excel spreadsheet to Sql Server 2008 table
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Bulk insert using stored procedure
  28. Connect different Windows User in SQL Server Management Studio (2005 or later)
  29. How to Select Every Row Where Column Value is NOT Distinct
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment