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

15 votes244 views2 answers
How to sort names in alphabetical order in sql
SQL
1 vote99 views1 answer
How to select random rows from table
SQL
0 vote106 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
0 vote102 views1 answer
How to order result of subquery in select
SQL
0 vote159 views1 answer
<sql:datasource var="Snapsho"
SQL
92 votes295 views6 answers
Substring
SQL
0 vote132 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
5 votes104 views3 answers
Mysql check if null or empty string
SQL
0 vote102 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote111 views1 answer
Sql examples from framework
SQL