Query to get all records of Previous Month from specified Date in SQL Server

iammann

SOLVED CLOSED ACTIVE ANSWERED
User: iammann
Posted: on Apr 09, 2019 01:28 AM
Forum: SQL Server
Answer: 1
Views: 1480

Please consider below sql query by which i want to get data of last month.

SELECT opp.opp_partner, 
               Sum(margin.clientquote)                      AS 
               ClientFeeLastMonth, 
               Sum(margin.grossmargin) / Count(grossmargin) AS 
               AvgMarginLastMonth, 
               0                                            AS ClientFeeLastYear 
               , 
               0                                            AS 
               AvgMarginLastYear 
        FROM   [dbo].[tbproject_margindetails] margin 
               INNER JOIN tbopportunitydetails opp 
                       ON margin.opportunity_id = opp.opportunityid 
        WHERE  opp.servicearea = 'Technology' 
               AND opp.status <> '' 
               AND Month(opp.updatedon) = Month(Getdate()) - 1 
               AND Year(opp.updatedon) = Year(opp.updatedon)

How to get data of previous month

Download FREE API for Word, Excel and PDF in ASP.Net

pandeyis...

0 4

Reply
ANSWER
User: pandeyism
Replied: on Apr 09, 2019 07:42 AM
Modified: on Apr 10, 2019 03:32 AM
Report

Hi iammann,

Refer below sample.

HTML

DECLARE @TestDemo AS TABLE(ID INT IDENTITY, [Date] DATETIME)
INSERT INTO @TestDemo VALUES('01/02/2018')
INSERT INTO @TestDemo VALUES('02/2/2018')
INSERT INTO @TestDemo VALUES('03/3/2018')
INSERT INTO @TestDemo VALUES('04/05/2018')
INSERT INTO @TestDemo VALUES('02/08/2019')
INSERT INTO @TestDemo VALUES('03/03/2019')
INSERT INTO @TestDemo VALUES('08/11/2018')
INSERT INTO @TestDemo VALUES('01/02/2018')
DECLARE @Monthwise INT
SET @Monthwise = 4
SELECT  * FROM @TestDemo
WHERE DATEPART(MONTH, DATEADD(MONTH, 0, [Date])) = @Monthwise - 1 
OR DATEPART(MONTH, DATEADD(MONTH, 0, [Date])) = @Monthwise

Output

ID	Date
3	2018/03/03
4	2018/04/05
6	2019/03/03

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Query to get all records of Previous Month from specified Date in SQL Server

Company

Explore

Follow us

Contact Us