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 vote172 views1 answer
Delete dublicate rows sql
SQL
3 votes152 views2 answers
Mysql time
SQL
0 vote234 views1 answer
Sql server system messeges
SQL
0 vote162 views2 answers
How to display enum value sql server
SQL
1 vote155 views3 answers
Mysql connection string
SQL
0 vote176 views1 answer
Java spring boot connect to sql server
SQL
0 vote154 views1 answer
Xampp increame mysql speed
SQL
24 votes158 views4 answers
Postgres delete database
SQL
0 vote170 views2 answers
Mysql missin expression near on
SQL
-1 vote210 views3 answers
MAKE TABLE FIT in oracle sql
SQL