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 vote203 views1 answer
Select new table sql
SQL
0 vote194 views1 answer
Casterar postgres
SQL
4 votes204 views1 answer
Search column by name mysql
SQL
0 vote189 views3 answers
Between keyword sql
SQL
-1 vote220 views2 answers
Full join sql
SQL
0 vote198 views1 answer
How to move a column to different spot mysql
SQL
1 vote252 views1 answer
Top 10 rows in mysql
SQL
1 vote183 views1 answer
Convert rows to string sql server
SQL
6 votes194 views2 answers
Sql sequence
SQL
1 vote228 views1 answer
How to give access to database in postgresql server to another user
SQL