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

3 votes148 views1 answer
Show index table
SQL
1 vote152 views1 answer
Tsql random number
SQL
13 votes147 views4 answers
Mysql select last 10 rows
SQL
1 vote160 views1 answer
Postgresql round double precision
SQL
0 vote158 views1 answer
Sql not exists
SQL
3 votes158 views1 answer
Sql print all names that start with a given letter
SQL
0 vote206 views1 answer
Tsql find procedure with name
SQL
0 vote149 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
11 votes150 views1 answer
Sql query to find duplicates in column
SQL
1 vote167 views1 answer
Check if mysql is installed
SQL