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 vote301 views1 answer
How to select all attributes from a row if there is a certain string in it MySQL
SQL
-1 vote357 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote269 views1 answer
C# datetime to sql server datetime
SQL
0 vote267 views1 answer
Difference between 2 query results sql server
SQL
0 vote288 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
0 vote276 views1 answer
Prepared statement mysql java delete selected rows
SQL
3 votes302 views1 answer
Sql print all names that start with a given letter
SQL
0 vote269 views2 answers
Azure sql-datenbank
SQL
15 votes295 views3 answers
Postgresql change column type
SQL
1 vote273 views1 answer
Xampp import sql file command line
SQL