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

2 votes196 views2 answers
Mysql user access to database
SQL
0 vote206 views1 answer
MySql Modify Increment
SQL
1 vote198 views1 answer
Load sql into mamp
SQL
12 votes285 views4 answers
How to drop all tables in postgresql
SQL
0 vote196 views1 answer
Mysql Selected All Duplicate Rows
SQL
1 vote185 views1 answer
Copy postgres table from one schema into another
SQL
-1 vote249 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote230 views1 answer
Compare strings lexicographically in sql
SQL
0 vote215 views1 answer
Mysql pv progres
SQL
2 votes234 views1 answer
Oracle kill session by sql_id
SQL