Display count of records month wise in SQL Server

Hi Bhavesh23,

Refer below query.

Database

For this example I have used of Northwind database that you can download using the link given below.

Download Northwind Database

SQL

SELECT LEFT(DATENAME(MONTH, OrderDate), 3) 'Month.',COUNT(*) 'Record' 
FROM Orders 
GROUP BY LEFT(DATENAME(MONTH, OrderDate), 3)
ORDER BY
CASE 
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Jan' THEN 0
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Feb' THEN 1
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Mar' THEN 2
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Apr' THEN 3
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'May' THEN 4
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Jun' THEN 5
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Jul' THEN 6
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Aug' THEN 7
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Sep' THEN 8
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Oct' THEN 9
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Nov' THEN 10
	WHEN LEFT(DATENAME(MONTH, OrderDate), 3) = 'Dec' THEN 11
END

Output

Then use the query to display in chart.