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