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 vote203 views1 answer
Oracle job class
SQL
1 vote204 views4 answers
Fatal database postgres does not exist
SQL
0 vote206 views1 answer
How to add timestamp column in mysql
SQL
0 vote205 views1 answer
Mysql read row
SQL
2 votes280 views1 answer
Creating a view SQL
SQL
7 votes235 views3 answers
Sql server check if temp table exists
SQL
2 votes227 views1 answer
Oracle list duplicates
SQL
0 vote248 views1 answer
Oracle sql date winter time
SQL
1 vote185 views1 answer
PLS-00225 type
SQL
3 votes220 views1 answer
Start mysql server by terminal in linux
SQL