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 vote217 views1 answer
Running mysql from bash sc
SQL
1 vote195 views1 answer
Show table columns
SQL
0 vote241 views1 answer
How to change mysql root password in windows 10
SQL
0 vote196 views1 answer
Oracle right characters
SQL
3 votes200 views3 answers
Your password does not satisfy the current policy requirements
SQL
1 vote197 views1 answer
Delete mysql from mac
SQL
1 vote199 views1 answer
How to make a select in sql
SQL
0 vote247 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote213 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote212 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL