/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

4 votes268 views2 answers
How to insert ip address in mysql using php
SQL
-1 vote267 views1 answer
Add column alter table default value
SQL
3 votes278 views1 answer
Oracle show trigger code
SQL
1 vote326 views1 answer
Drop colum oracle 18c
SQL
0 vote242 views1 answer
Duplicate foreign key constraint name
SQL
0 vote281 views1 answer
Import Data in MySQL without using any other software
SQL
-1 vote257 views2 answers
Full join sql
SQL
0 vote279 views1 answer
Greater than or equal to symbol in postgres
SQL
11 votes289 views2 answers
You are using safe update mode
SQL
11 votes291 views5 answers
Laravel db facade
SQL