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 vote295 views1 answer
Find usage of table in sql server
SQL
0 vote286 views1 answer
Mysql workbench indent formatting
SQL
1 vote277 views1 answer
Add constraint sql
SQL
16 votes295 views1 answer
Sql comment'
SQL
5 votes272 views2 answers
Oracle tables with column name
SQL
2 votes304 views1 answer
Sql server: select column values as comma separated string
SQL
6 votes309 views1 answer
Postgresql add enum value
SQL
4 votes275 views1 answer
Adding data to table in sql python
SQL
0 vote313 views1 answer
Hashpass
SQL
0 vote288 views1 answer
Pass array parameter to stored procedure c#
SQL