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

9 votes202 views2 answers
Mysql change value
SQL
2 votes209 views1 answer
Scaffold npgsql net core
SQL
0 vote235 views1 answer
Mysql faster delete
SQL
0 vote406 views1 answer
Power bi connect to postgresql
SQL
0 vote171 views3 answers
Mysql calculate age from date of birth
SQL
0 vote203 views1 answer
Oracle shrink table
SQL
2 votes194 views1 answer
Oracle cpu per session
SQL
11 votes221 views3 answers
How to get last row of table in sql
SQL
0 vote192 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote212 views1 answer
How to declare variable date in mysql
SQL