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 vote147 views1 answer
A network or instance-specific error sql server
SQL
1 vote131 views1 answer
Sql select table header
SQL
10 votes134 views1 answer
Oracle dependencies table
SQL
5 votes133 views1 answer
Oracle nls instance
SQL
1 vote135 views2 answers
Mysql trim spaces
SQL
0 vote126 views2 answers
Pl sql auto increment
SQL
0 vote123 views1 answer
Sum sqlserver
SQL
2 votes129 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote125 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
18 votes123 views2 answers
Sql inner join
SQL