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 vote228 views1 answer
Query for backup a database at another location in file system
SQL
2 votes199 views1 answer
Oracle table size
SQL
13 votes231 views3 answers
List all the tables in sql
SQL
0 vote330 views2 answers
Mysql insert rows to another database
SQL
0 vote211 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote201 views1 answer
Get all employees if name ends with in sql
SQL
4 votes212 views1 answer
Create column mysql terminal
SQL
0 vote240 views1 answer
Mysql récupérer le code création de vue
SQL
-1 vote254 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote195 views1 answer
Drop constraint in ms sql
SQL