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

3 votes109 views1 answer
System.debug apex
SQL
0 vote154 views1 answer
Grant access on table in oracle
SQL
0 vote181 views1 answer
SQL Cut part string
SQL
0 vote158 views2 answers
How to generate a unique random number in mysql
SQL
0 vote149 views1 answer
How to see password mysql vestacp
SQL
0 vote159 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote147 views1 answer
Difference between min and max date sql
SQL
17 votes195 views6 answers
Get last record in sql
SQL
0 vote146 views4 answers
Restart MySQL
SQL
13 votes158 views4 answers
What is sql
SQL