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 vote186 views2 answers
Change database postgres
SQL
1 vote184 views1 answer
Sql drop schema
SQL
3 votes173 views2 answers
Sql server current date without time
SQL
1 vote186 views1 answer
Update from select oracle
SQL
3 votes231 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote188 views1 answer
How to add more columns to a table in mysql
SQL
1 vote180 views1 answer
Mariadb alter user host
SQL
1 vote258 views3 answers
Date_add mysql
SQL
0 vote197 views2 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'world.admin_tasks' doesn't exist
SQL
0 vote204 views1 answer
Consecutive numbers sql
SQL