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 vote173 views1 answer
Mysql backup skip table
SQL
0 vote176 views1 answer
Get date ISO in psql
SQL
11 votes169 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote133 views1 answer
Raven ql select count
SQL
0 vote191 views2 answers
What is the default password for sql server sa
SQL
-2 votes178 views3 answers
Sqlite reset autoincrement
SQL
0 vote182 views3 answers
Postgresql allow remote connections
SQL
0 vote190 views1 answer
Insert value in identity
SQL
0 vote163 views1 answer
Can't connect to postgresql mac os
SQL
5 votes242 views1 answer
Oracle source query
SQL