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 vote146 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote153 views1 answer
Creating h2 database in relative directory eclopse
SQL
5 votes143 views3 answers
Oracle list columns in schema
SQL
6 votes129 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
6 votes141 views3 answers
Mysql first day of year
SQL
0 vote141 views1 answer
Sql select rows with different values in one column
SQL
2 votes123 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote143 views1 answer
Django mysqlclient connection string
SQL
2 votes132 views2 answers
Exec procedure pl sql
SQL
0 vote137 views1 answer
How to set sql_mode for a query in CI model
SQL