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 vote338 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote350 views1 answer
Mysql add text to existing field
SQL
14 votes394 views6 answers
Finding duplicate rows mysql
SQL
1 vote341 views1 answer
Sqlite show columns in table
SQL
0 vote333 views1 answer
Get only structure database mysql
SQL
2 votes335 views1 answer
Set boolean flasksql
SQL
0 vote311 views1 answer
Declaring variables in pl sql
SQL
1 vote332 views4 answers
Mysqldump 1 table only
SQL
0 vote378 views1 answer
Apt install sql server
SQL
0 vote341 views1 answer
Mysql type for large numbers with many decimal
SQL