Window function to forward fill

-- USE LAG IGNORING NULLS AND GRAB PREVIOUS VALUE. FILTER OPPOSITE DIRECTION TO GET BACK FILL
SELECT  
		DATE,
        GROUP,
        REVENUE
        COALESCE(REVENUE, LAG(REVENUE) IGNORE NULLS OVER (PARTITION BY GROUP order by DATE), LAG(REVENUE) IGNORE NULLS OVER (PARTITION BY GROUP order by DATE DESC)) as FILL_VALUE
FROM _ADS A

Similar codes

2 votes344 views2 answers
How to view created temporary tables in mysql
SQL
3 votes400 views1 answer
Unsigned int in mysql
SQL
0 vote338 views1 answer
Changer un mot de passe mysql
SQL
3 votes359 views1 answer
Select database in sql
SQL
1 vote356 views1 answer
Sql sort column by date
SQL
0 vote363 views1 answer
Mysql error 1251
SQL
0 vote383 views1 answer
How to move a columns location in mysql
SQL
5 votes377 views4 answers
Restart the psql server windows
SQL
3 votes366 views2 answers
Postgres inner join vs join
SQL
0 vote417 views1 answer
Kimball data warehouse sql calendar
SQL