How do I perform a GROUP BY on an aliased column in SQL Server?

by

You pass the expression you want to group by rather than the alias 

SELECT       LastName + ', ' + FirstName AS 'FullName'
FROM         customers
GROUP BY      LastName + ', ' + FirstName

More Related Contents:

  1. SQL dot notation
  2. Curly braces in T-SQL
  3. Syntax of for-loop in SQL Server
  4. Is it possible to write single query on two table which are not connected to each other?
  5. How to create a specific SQL Server stored procedure? [closed]
  6. SQL Server dynamic PIVOT query?
  7. SQL Server – Best way to get identity of inserted row?
  8. Should I use != or for not equal in T-SQL?
  9. How to update two tables in one statement in SQL Server 2005?
  10. SQL Server Process Queue Race Condition
  11. Is the NOLOCK (Sql Server hint) bad practice?
  12. Creating an index on a table variable
  13. SQL – Subtracting a depleting value from rows
  14. OR is not supported with CASE Statement in SQL Server
  15. How to set variable from a SQL query?
  16. Compare DATETIME and DATE ignoring time portion
  17. Equivalent of Oracle’s RowID in SQL Server
  18. Dynamic update statement with variable column names
  19. How to select only the first rows for each unique value of a column?
  20. SQL Server (TSQL) – Is it possible to EXEC statements in parallel?
  21. SQL “between” not inclusive
  22. Unordered results in SQL
  23. Using PIVOT in SQL Server 2008
  24. SQL Server replace, remove all after certain character
  25. Inserting rows into a table with one IDENTITY column only [duplicate]
  26. ORDER BY items must appear in the select list if SELECT DISTINCT is specified
  27. How do I compare 2 rows from the same table (SQL Server)?
  28. Cumulative Total in MS Sql server [duplicate]
  29. Why is RAND() not producing random numbers?
  30. Should every SQL Server foreign key have a matching index? [closed]

Leave a Comment