Count records for every month in a year

by 
SELECT    COUNT(*) 
FROM      table_emp 
WHERE     YEAR(ARR_DATE) = '2012' 
GROUP BY  MONTH(ARR_DATE)

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  3. sql server 2008 management studio not checking the syntax of my query
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. How to create a table from select query result in SQL Server 2008 [duplicate]
  6. Parse comma-separated string to make IN List of strings in the Where clause
  7. SQL query to split column data into rows
  8. OPTION (RECOMPILE) is Always Faster; Why?
  9. Rename column SQL Server 2008
  10. Compare DATETIME and DATE ignoring time portion
  11. Split function in SQL Server 2008
  12. Remove numbers from string sql server
  13. How to find third or nᵗʰ maximum salary from salary table?
  14. SQL “between” not inclusive
  15. How do I edit a table in order to enable CASCADE DELETE?
  16. sql group by only rows which are in sequence
  17. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  18. SQL Server SELECT LAST N Rows
  19. How can I group by date time column without taking time into consideration
  20. The transaction log for the database is full
  21. How to retrieve field names from temporary table (SQL Server 2008)
  22. When using GETDATE() in many places, is it better to use a variable?
  23. How do I change db schema to dbo
  24. Why & When should I use SPARSE COLUMN? (SQL SERVER 2008)
  25. Safest way to get last record ID from a table
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment