sql server - SQL: aggregate function or the GROUP BY - Stack Overflow

Details

Description

If you are selecting separate columns, they ALL need to appear in the GROUP BY clause unless they are aggregate functions.

See here: http://msdn.microsoft.com/en-us/library/ms177673.aspx

e.g.

SELECT TOP 20


#subtotal #select #order_ıd #orders #customermessage

https://stackoverflow.com/questions/12216825/sql-aggregate-function-or-the-group-by https://stackoverflow.com/questions/12216825/sql-aggregate-function-or-the-group-by