how to select all data according to month and year sql

Question

hello friends i want to select my data according to monthly and yearly i e.m select all data like: oct 2016 and show all data nov 2016 and show all data

Devendra Kumar · Answer

i have a blog in which column name: like : blog title and descriptions and post date simple i want to show nov month total post 1. 2. 3. dec month total post

Manas Mohapatra · Answer

Did you provide correct value in SQL query. Please provide query details and what result we need?

Devendra Kumar · Answer

hello Manas Mohapatra sir i will use this query but it not show my all column

Devendra Kumar · Answer

Manas Mohapatra thanks for rply i will tryt his

Manas Mohapatra · Answer

Try with below code: CREATE TABLE #Sales (SalesId INT IDENTITY(11) SalesDate DateTime) --Fetch all data order by year and month SELECT YEAR (SalesDate) [ Year ] MONTH (SalesDate) [ Month ] DATENAME( MONTH SalesDate) [ Month Name ] COUNT (1) [Sales Count ] FROM #Sales GROUP BY YEAR (SalesDate) MONTH (SalesDate) DATENAME( MONTH  SalesDate) ORDER BY 12 --Fetch based on year and month SELECT YEAR (SalesDate) [ Year ] MONTH (SalesDate) [ Month ] DATENAME( MONTH SalesDate) [ Month Name ] COUNT (1) [Sales Count ] FROM #Sales WHERE YEAR (SalesDate) = 2016 AND MONTH (SalesDate) = 1