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 votes333 views1 answer
Mysql id of inserted row
SQL
0 vote388 views1 answer
Drop table BigQuery table columns
SQL
19 votes302 views2 answers
Mysql add column after another
SQL
1 vote305 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
1 vote321 views1 answer
Create new table from old table with data
SQL
0 vote347 views2 answers
Identity syntax in sql
SQL
0 vote299 views1 answer
Sql delete dastabase
SQL
0 vote297 views1 answer
Write sql query to show the details start from digit
SQL
4 votes295 views1 answer
Oracle error compilation line
SQL
22 votes311 views3 answers
SQL CHEATSHEET
SQL