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

0 vote217 views1 answer
Sql constarint
SQL
0 vote192 views1 answer
Sauvegarde complète my sql
SQL
0 vote187 views1 answer
Sql create table with datetime automatically
SQL
0 vote218 views1 answer
"Hello User Name"
SQL
3 votes191 views1 answer
Mysql load sql from file
SQL
0 vote221 views1 answer
Create synonym for dblink in oracle
SQL
0 vote188 views1 answer
2020 new year
SQL
3 votes207 views2 answers
Sql server current date without time
SQL
26 votes197 views6 answers
Modify column name in sql
SQL
0 vote204 views1 answer
Sql delete from with relation
SQL