Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

I am writing a query in which I have to get the data for only the last year. What is the best way to do this?

SELECT ... FROM ... WHERE date > '8/27/2007 12:00:00 AM'

2 Answers

0 votes
by (40.7k points)

By using the below code, you can add -1 year to the current date:

SELECT ... From ... WHERE date > DATEADD(year,-1,GETDATE())

0 votes
ago by (1.5k points)

Try this query,

SELECT * FROM Tablename WHERE date >= DATEADD(YEAR, -1, GETDATE());

Related questions

0 votes
1 answer
asked Jul 22, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer
asked Jul 9, 2019 in SQL by Tech4ever (20.3k points)
0 votes
1 answer

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...