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

1 vote313 views1 answer
Oracle add proxy
SQL
2 votes342 views1 answer
Sql percentage with % rounded down
SQL
1 vote329 views1 answer
Best sql course
SQL
1 vote326 views2 answers
How to combine 2 tables in MySQL
SQL
0 vote300 views1 answer
Mysql command prompt date insert format
SQL
0 vote329 views1 answer
Sql put two columns into one
SQL
1 vote324 views1 answer
Regular expression in sql server
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote321 views1 answer
Cast float mysql
SQL
0 vote335 views1 answer
Oracle sql add column auto generated value
SQL