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 vote192 views1 answer
Narural join
SQL
0 vote265 views1 answer
Oracle create package specification
SQL
4 votes180 views1 answer
Fetch first 10 rows in oracle sql developer
SQL
1 vote139 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote190 views1 answer
Mysql select smaller of two values
SQL
3 votes193 views3 answers
Mysql declare variable
SQL
-1 vote185 views2 answers
How to display top 50 rows?
SQL
4 votes187 views1 answer
Oracle show errors
SQL
3 votes183 views2 answers
Mysql update row
SQL
0 vote208 views1 answer
To Create directory
SQL