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

3 votes201 views1 answer
Sql add two values together
SQL
-1 vote156 views1 answer
Create view in mysql workbench
SQL
3 votes118 views1 answer
Sql select all
SQL
0 vote141 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote132 views1 answer
Sql cheetsheet
SQL
1 vote134 views1 answer
Select from describe sql
SQL
3 votes144 views1 answer
Mysql replace string in table
SQL
8 votes136 views2 answers
Safe update mode in mysql
SQL
2 votes122 views1 answer
How to add where command in update comand with joins
SQL
0 vote142 views1 answer
How to populate a table in MySQL from and existing csv file
SQL