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 votes304 views2 answers
Set value to null sql
SQL
0 vote258 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL
2 votes262 views2 answers
Convert_tz mysql
SQL
1 vote273 views1 answer
How to lock table in mysql
SQL
4 votes242 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote251 views2 answers
Postgresql get last day of month
SQL
0 vote276 views2 answers
While mysql
SQL
0 vote261 views1 answer
Delete record by id sql
SQL
0 vote235 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
1 vote251 views2 answers
Sql left characters
SQL