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 vote257 views1 answer
Update set with inner join oracle
SQL
13 votes272 views3 answers
Sql select from multiple tables without join
SQL
1 vote290 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote292 views1 answer
Mysqldump: error:
SQL
0 vote255 views2 answers
Mysql multiply
SQL
3 votes254 views3 answers
Mysql get table size
SQL
34 votes282 views5 answers
Oracle alter table add column
SQL
0 vote241 views1 answer
Parsing float to int in mysql
SQL
-2 votes275 views2 answers
Union vs union all in sql
SQL
3 votes284 views1 answer
Mysql insert on dupèlicate
SQL