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 votes137 views1 answer
Sql online test questions and answers
SQL
5 votes126 views1 answer
Oracle ora-00054 causes
SQL
0 vote134 views2 answers
How to create a table from another table in sql derby
SQL
0 vote121 views1 answer
Declare date variable sql
SQL
13 votes122 views6 answers
Current date sql
SQL
0 vote125 views2 answers
How to update date in oracle
SQL
8 votes135 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
34 votes121 views6 answers
Sql change data type
SQL
0 vote151 views1 answer
Find wordpress version in database
SQL
0 vote135 views1 answer
Databricks install odbc driver connect to sql server
SQL