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

2 votes113 views1 answer
Sql server find table name
SQL
0 vote112 views1 answer
Oracle query archive mode
SQL
0 vote117 views2 answers
Sql having multiple conditions
SQL
3 votes118 views2 answers
SqlMessage: "Host '192.168.64.1' is not allowed to connect to this MariaDB server
SQL
14 votes113 views3 answers
Delete all records from table except sql
SQL
0 vote107 views1 answer
Alter table fulltext
SQL
2 votes121 views1 answer
Express api ith mysql data
SQL
0 vote138 views1 answer
Sql today at midnight
SQL
0 vote120 views1 answer
Display first three characters sql
SQL
0 vote112 views1 answer
Json_remove mysql
SQL