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

13 votes326 views4 answers
What is sql
SQL
1 vote236 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote286 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
4 votes298 views3 answers
Copy table postgres
SQL
15 votes294 views3 answers
Find duplicate keys in mysql
SQL
1 vote262 views1 answer
Full text index mysql
SQL
0 vote315 views1 answer
Psql get table data types
SQL
0 vote250 views1 answer
Count char in java
SQL
0 vote297 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote301 views1 answer
Sql server pivot rows to columns
SQL