/SQL/Comparing with today and yesterday record in sql query

Comparing with today and yesterday record in sql query

declare @bgn_dt date = '2017-12-15' --set by OP
    , @end_dt date = '2017-12-22' --set by OP
    , @lag_dt date;

set @lag_dt = (select max(MyDate) from #myTable where MyDate < @bgn_dt) --get the "yesterday" that the @bgn_dt will need

select a.MyDate
, a.SalesTotal
, format(((1.0 * a.SalesTotal) / a.SalesTotalPrevDay) - 1, '0%') as SalesTotalChange
from (
    select t.MyDate
    , t.SalesTotal
    , lag(t.SalesTotal, 1, NULL) over (/*partition by (if needed)*/ order by t.MyDate asc) as SalesTotalPrevDay
    from #myTable as t
    where 1=1
    and t.MyDate between @lag_dt and @end_dt
    ) as a
where 1=1
and a.MyDate >= @bgn_dt

Source: stackoverflow.com

Similar codes

1 vote247 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
-3 votes301 views8 answers
Sql to c# linq converter online
SQL
0 vote221 views1 answer
Postgresql extract hour and minutes from timestamp
SQL
0 vote223 views1 answer
Alter table fulltext
SQL
0 vote243 views1 answer
Sql select column name like from multiple tables
SQL
12 votes230 views1 answer
Docker run mysql image
SQL
0 vote220 views1 answer
Sql server 2012 create or alter procedure
SQL
0 vote217 views1 answer
Sum value by month sql
SQL
3 votes247 views1 answer
Start mysql server linux terminal
SQL
0 vote243 views1 answer
How to install postgresql on wsl
SQL