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

5 votes124 views1 answer
Oracle add time to date
SQL
2 votes122 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote111 views1 answer
Search column name sql
SQL
1 vote125 views1 answer
Drop primary key oracle
SQL
0 vote74 views1 answer
Mitigation of sql injection
SQL
14 votes133 views1 answer
Oracle alter table add column not null
SQL
0 vote111 views1 answer
Oracle activate program
SQL
0 vote112 views1 answer
Oracle execute package dblink
SQL
0 vote126 views1 answer
Python mysql query to dataframe
SQL
0 vote73 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL