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 vote114 views1 answer
Sql create table with references not primary key
SQL
0 vote126 views1 answer
Postgresql print sessions using the database
SQL
0 vote137 views1 answer
How to find date from date table in sql
SQL
2 votes112 views1 answer
Mysql clear screen
SQL
1 vote132 views2 answers
Mysql extract number from string
SQL
0 vote112 views1 answer
Sql server pivot rows to columns
SQL
0 vote115 views2 answers
Sql server select where date
SQL
0 vote136 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote128 views1 answer
Delete hangfire retries list
SQL
0 vote113 views1 answer
Split string by comma in sql server
SQL