Select last 30 days sql

Sql last 7 days

 SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
 FROM News 
 WHERE CreatedDate >= DATEADD(day,-7, GETDATE())

Source: stackoverflow.com

Select last 30 days sql

--EXAMPLE -30 days
select o_orderkey, o_orderstatus, o_orderdate, o_totalprice from orders where o_orderdate >= current_date -30

Similar codes

0 vote255 views1 answer
Sql examples from your work
SQL
0 vote268 views2 answers
Timing sql queries
SQL
0 vote258 views1 answer
Setting default value for Boolean data type in SQL
SQL
10 votes248 views2 answers
Mysql select timestamp group by day
SQL
0 vote223 views1 answer
Sql table to store status
SQL
4 votes289 views1 answer
Data types in sql
SQL
18 votes255 views2 answers
Sql comments
SQL
0 vote266 views1 answer
Multiple tricky query in sql server
SQL
6 votes270 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote266 views1 answer
Mysql use password error
SQL