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 vote327 views1 answer
Sql delete where x or y or z
SQL
1 vote354 views1 answer
Mysql search like order by best match
SQL
0 vote354 views1 answer
T-sql update table variale
SQL
0 vote352 views1 answer
Sql declare variable single line
SQL
22 votes321 views3 answers
Sql cheat sheet
SQL
3 votes291 views1 answer
How to get list of synonyms in oracle
SQL
0 vote332 views1 answer
Postgresql certain first 4 characters in string
SQL
11 votes361 views2 answers
Oracle saurce code
SQL
0 vote350 views1 answer
Repeatable read trong sql server
SQL
4 votes331 views1 answer
Sql any
SQL