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 vote136 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote126 views1 answer
Sql server select ignore dupplicates
SQL
1 vote123 views1 answer
Where date = max(date) in sql
SQL
0 vote123 views1 answer
Suse status MySQL
SQL
0 vote168 views1 answer
Mysql show schema
SQL
0 vote120 views2 answers
Update information in a mysql column
SQL
0 vote124 views1 answer
Change date format in oracle query
SQL
0 vote143 views1 answer
How to fetch data from database in sql
SQL
13 votes258 views4 answers
Sql joining 3 tables
SQL
1 vote144 views2 answers
Copy table in sql
SQL