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 vote143 views1 answer
Every Derived yable must have its own alias
SQL
2 votes204 views2 answers
How to DROP a table in mysql
SQL
0 vote135 views1 answer
Dbms_output sql developer
SQL
1 vote126 views1 answer
Oracle lock user
SQL
3 votes169 views2 answers
Find string in stored procedure sql server
SQL
7 votes132 views3 answers
Postgresql dump and restore db
SQL
-1 vote149 views1 answer
Mysql select count if contains
SQL
0 vote184 views1 answer
MySQL update with subquery
SQL
0 vote144 views1 answer
Mysql random number between 1 and 100
SQL
0 vote149 views1 answer
Sql delimiter to columns
SQL