/SQL/How to add amount between date in sql

How to add amount between date in sql

Sql add days to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(day, 1, '2017/08/25')

How to add amount between date in sql

mysql> select sum(Value) from DemoTable1444 where PurchaseDate between '2019-10-02' and '2019-12-31';

Source: tutorialspoint.com

Similar codes

10 votes332 views4 answers
Fetch first 5 characters of the string in sql
SQL
2 votes339 views3 answers
How to pass password mysql command line
SQL
10 votes331 views4 answers
Primary key sql
SQL
0 vote367 views1 answer
Mysql bash execute sql file
SQL
1 vote327 views1 answer
Mysql show current queries
SQL
0 vote353 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
4 votes346 views4 answers
Pl sql output
SQL
5 votes354 views3 answers
Bash: mysql: command not found
SQL
12 votes355 views4 answers
How to take database dump in postgresql
SQL
-1 vote423 views1 answer
Sql vs nosql or mysql vs mongodb
SQL