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

22 votes139 views3 answers
SQL CHEATSHEET
SQL
0 vote140 views1 answer
Sql select where more than one record exists
SQL
7 votes128 views3 answers
Postgresql dump and restore db
SQL
1 vote132 views1 answer
Window function mysql
SQL
2 votes136 views2 answers
Spring where to put the data sql
SQL
0 vote144 views1 answer
Google cloud sql postgres url example
SQL
11 votes312 views4 answers
Round in sql
SQL
0 vote128 views1 answer
Do postgresql
SQL
0 vote145 views1 answer
Allow null in psql
SQL
11 votes128 views4 answers
Query DISTINCT
SQL