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 vote182 views1 answer
Online sql testing tool
SQL
4 votes187 views4 answers
Date less than in sql
SQL
0 vote182 views1 answer
Sql server select furst day of current year
SQL
0 vote191 views1 answer
Denormalise SQL command
SQL
0 vote239 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote219 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote184 views1 answer
Phpmyadmin tabellentyp ändern
SQL
-1 vote188 views1 answer
Raise ImproperlyConfigured('mysqlclient 1.3.13 or newer is required; you have %s.' % Database.__version__) django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.9.3.
SQL
8 votes219 views1 answer
Mysql restore database
SQL
3 votes184 views1 answer
Créer une table sql
SQL