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 vote204 views1 answer
Psql initialization
SQL
2 votes179 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
1 vote167 views1 answer
Clear screen command in psql
SQL
0 vote189 views1 answer
How to check event scheduler status mysql
SQL
18 votes179 views2 answers
Sql inner join
SQL
13 votes167 views3 answers
Sql online code
SQL
0 vote196 views1 answer
Get only one row in mysql
SQL
4 votes186 views4 answers
Oracle tablespace tables list
SQL
0 vote184 views1 answer
Console output pl sql
SQL
0 vote170 views1 answer
Java sql connection
SQL