[Solved] How to get last 3 month name in sql server
[ad_1] Sorry @Imrul Kaesh , there is some mistake on the query. I didn’t filter the last 3 months by ItemId. I have updated my query as below, please have a try: WITH Last3Month AS ( SELECT DISTINCT TOP 3 MONTH(IssueDate) AS Mth FROM Issue WHERE ItemId = 452 –Please add this WHERE Clause ORDER … Read more