How to get the records of last month using sql query in SQL server?

To get the last month records using SQL server, you can use the query below, It will give output of last month(for example if the month is May-2018, it will give April-2018 data)

SELECT * 
FROM TableName
WHERE DATEPART(m, DateCreated) = DATEPART(m, DATEADD(m, -1, getdate()))
AND DATEPART(yyyy, DateCreated) = DATEPART(yyyy, DATEADD(m, -1, getdate()))

In the above query, TableName is the table from which you want to fetch data while DateCreated is the column in which you have saved data as datetime

Now, to get Last 30 days records use the SQL server query as below

SELECT * FROM  TableName
WHERE  DateCreated >= DATEADD(day,-30, getdate()) 
and    DateCreated <= getdate()

If you have DateTime Column saved as a string first convert the string into datetime, your above query can be converted as below

SELECT * FROM  TableName 
WHERE  CONVERT(datetime, DateCreated) >= DATEADD(day,-30, getdate()) 
and    CONVERT(datetime, DateCreated) <= getdate()

So, any of the above query, depending upon your needs will work.

You can also try this solution to get last month data in SQL

SELECT * FROM TableName
WHERE 
YEAR(DateColumn) = DATEPART(yyyy, DATEADD(m, -1, getdate()))
AND 
MONTH(DateColumn) = DATEPART(m, DATEADD(m, -1, getdate()))

This will return you last month results only.