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 vote311 views2 answers
Find a column in all tables mysql
SQL
0 vote313 views1 answer
Gcloud check sql
SQL
0 vote335 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
1 vote326 views1 answer
Mysql dump specific tables
SQL
2 votes349 views1 answer
Dbms transaction (psql)
SQL
0 vote337 views1 answer
Bidirectional outer join sql
SQL
1 vote331 views1 answer
Mysql return text after a final full stop
SQL
0 vote322 views2 answers
Transaction php
SQL
1 vote304 views1 answer
Mysql column start with string
SQL
2 votes297 views2 answers
Insert all in sql
SQL