SQL grouping by month and year

by 
SELECT CAST(MONTH(date) AS VARCHAR(2)) + '-' + CAST(YEAR(date) AS VARCHAR(4)) AS Mjesec, SUM(marketingExpense) AS SumaMarketing, SUM(revenue) AS SumaZarada 
FROM [Order]
WHERE (idCustomer = 1) AND (date BETWEEN '2001-11-3' AND '2011-11-3')
GROUP BY CAST(MONTH(date) AS VARCHAR(2)) + '-' + CAST(YEAR(date) AS VARCHAR(4))

Or as @40-Love mentioned you can cast with leading zeroes:

GROUP BY 
  CAST(YEAR(date) AS VARCHAR(4)) + '-' + right('00' + CAST(MONTH(date) AS VARCHAR(2)), 2)

More Related Contents:

  1. Case statement for multiple columns
  2. SQL where clause odd behavior [closed]
  3. SQL Server Exec issue [closed]
  4. Count(*) vs Count(1) – SQL Server
  5. How do I escape a single quote in SQL Server?
  6. Unpivot with column name
  7. Selecting data from two different servers in SQL Server
  8. Is a view faster than a simple query?
  9. How to convert DateTime to VarChar
  10. How to rewrite IS DISTINCT FROM and IS NOT DISTINCT FROM in SQL Server 20008R2?
  11. How do I delete from multiple tables using INNER JOIN in SQL server
  12. SQL : BETWEEN vs =
  13. Stored Procedure with optional “WHERE” parameters
  14. SQL Server: Howto get foreign key reference from information_schema?
  15. SCOPE_IDENTITY() for GUIDs?
  16. SQL Server convert string to datetime
  17. Should I design a table with a primary key of varchar or int?
  18. Check If the string contains accented characters in SQL?
  19. Need to list all triggers in SQL Server database with table name and table’s schema
  20. Count based on condition in SQL Server
  21. Get previous and next row from rows selected with (WHERE) conditions
  22. Does Sql JOIN order affect performance?
  23. Best equivalent for IsInteger in SQL Server
  24. Syntax of for-loop in SQL Server
  25. Using tuples in SQL “IN” clause
  26. Why does ISNUMERIC(‘.’) return 1?
  27. Cumulative Total in MS Sql server [duplicate]
  28. What does ON [PRIMARY] mean?
  29. Export table data from one SQL Server to another
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment