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 vote208 views1 answer
Mysql relationships between tables
SQL
1 vote203 views1 answer
Liquibase alter column type / length
SQL
0 vote192 views1 answer
Mariadb set vertical output format
SQL
5 votes190 views4 answers
Upload database mysql command line
SQL
0 vote182 views1 answer
Sql server user permissions and roles
SQL
0 vote169 views1 answer
10000000000000000000 am to meters
SQL
5 votes186 views2 answers
Mysql import gzip db
SQL
0 vote176 views1 answer
Myswql show full processlist
SQL
0 vote219 views1 answer
Mysql case when on date
SQL
0 vote176 views1 answer
Contraint default SQL
SQL