How do I get last 12 months data in SQL Server?

How do I get last 12 months in SQL Server?

Here's the SQL query to get daily new sign ups and users in last 12 months in MySQL. mysql> select * from users where date_joined> now() - INTERVAL 12 month; In the above query, we use system function now() to get current datetime.

How do I get last 3 months records in SQL?

1SELECT *FROM Employee WHERE JoiningDate >= DATEADD(M, -3, GETDATE())2SELECT *FROM Employee WHERE JoiningDate >= DATEADD(MONTH, -3, GETDATE())3DECLARE @D INT SET @D = 3 SELECT DATEADD(M, @D, GETDATE())SQL Query to Get Last 3 Months Records in SQL Server

How do I get last 6 months data in SQL Server?

Instead of approximating the "current" date by selecting the MAX(date) the code could reference CAST(GETDATE() as DATE) to access the system datetime and cast it as type DATE. where [date] > dateadd(month, -6, cast(getdate() as date));

How do I get last 30 days records in SQL Server?

SELECT * FROM product WHERE pdate >= DATEADD(day, -30, getdate()).