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 vote160 views1 answer
How to populate a table in MySQL from and existing csv file
SQL
12 votes163 views5 answers
Rename table in mysql
SQL
4 votes158 views1 answer
T-sql get duplicate rows
SQL
21 votes145 views1 answer
Cheatsheet for sql
SQL
0 vote147 views1 answer
Components/Fields of Internal Table
SQL
8 votes152 views1 answer
How to check mysql version in xampp
SQL
0 vote147 views1 answer
Mysql subdate
SQL
0 vote153 views1 answer
How to insert multiple values in a single column in sql
SQL
4 votes180 views3 answers
Postgres drop all tables
SQL
11 votes145 views3 answers
Sqlite3 create table from another table
SQL