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 vote180 views1 answer
Sql select where more than one record exists
SQL
0 vote189 views2 answers
SQL Server Standard
SQL
6 votes213 views2 answers
Subtr Oracle ?
SQL
0 vote226 views1 answer
Authentication modes in sql server
SQL
18 votes139 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote170 views1 answer
Sql roll up rows into columns
SQL
0 vote159 views1 answer
Mysql select statement after index
SQL
0 vote167 views1 answer
Get all employee of salary if more than in sql
SQL
6 votes175 views3 answers
Mysql first day of year
SQL
0 vote340 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL