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

9 votes388 views3 answers
Sql delete where in
SQL
1 vote348 views1 answer
Oracle enable job
SQL
0 vote356 views1 answer
Oracle sql all days except weekends
SQL
0 vote336 views1 answer
Java sql connection
SQL
0 vote324 views1 answer
Sql transact create cursor with dynamic tables
SQL
13 votes320 views2 answers
Check if value is null mysql
SQL
5 votes324 views1 answer
Oracle ORA-00054 origin
SQL
0 vote372 views1 answer
Psql check if sql script is valid
SQL
0 vote322 views1 answer
Sql server count all tables rows
SQL
5 votes324 views1 answer
Oracle scan source ddl
SQL