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

1 vote354 views1 answer
Oracle check table space
SQL
0 vote328 views1 answer
Mysql select distinct date from timestamp
SQL
1 vote330 views1 answer
Select random sample sql
SQL
22 votes392 views3 answers
Year format in date mysql
SQL
1 vote392 views1 answer
Backup mysql schema only
SQL
0 vote352 views1 answer
Dapper run sql script with parameters
SQL
0 vote356 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote379 views1 answer
Sql server alter table add column tinyint
SQL
0 vote363 views1 answer
Hibernate with springboot mysql
SQL
0 vote369 views1 answer
Sql find leading space
SQL