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 vote282 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote147 views1 answer
Setval in postgres
SQL
6 votes129 views2 answers
How to copy data in sql
SQL
0 vote296 views1 answer
Dublicate row sql
SQL
1 vote151 views1 answer
Alter database datafile maxsize 32g
SQL
8 votes159 views2 answers
How to fetch data from database without last column
SQL
0 vote151 views1 answer
Foreign key multiple columns
SQL
0 vote131 views1 answer
Mysql isshow
SQL
0 vote134 views1 answer
Transalations from sql to Linq count and group by
SQL
1 vote189 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL