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 vote106 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
7 votes113 views1 answer
Sql server management studio turn on line numbers
SQL
3 votes119 views2 answers
How to open postgresql in windows
SQL
9 votes109 views4 answers
How to create new user and database postgresql in ubuntu
SQL
28 votes106 views4 answers
Show tables mysql
SQL
0 vote117 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
17 votes236 views4 answers
Show all tables in oracle
SQL
1 vote113 views2 answers
Datetrunc hour snowflake
SQL
6 votes147 views2 answers
Subtr Oracle ?
SQL
0 vote105 views1 answer
Mssql current date
SQL