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

1 vote188 views3 answers
Mariadb add foreign key
SQL
0 vote190 views1 answer
First mysql
SQL
0 vote202 views1 answer
Get who is hired in january in sql
SQL
14 votes203 views2 answers
Oracle export trigger ddl
SQL
0 vote196 views1 answer
How to to get current date in sql
SQL
0 vote182 views1 answer
Complete date is 1 year or not sql server
SQL
17 votes203 views2 answers
T_sql contains
SQL
1 vote277 views1 answer
Sql select contem uma palavra
SQL
0 vote193 views1 answer
Sql count null values in all columns
SQL
6 votes207 views1 answer
SQL insert all columns
SQL