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

4 votes327 views5 answers
Get last query in codeigniter 4
SQL
7 votes305 views1 answer
Sql server convert string to date
SQL
1 vote309 views1 answer
Describe table in sql
SQL
4 votes305 views1 answer
Create db table
SQL
6 votes308 views4 answers
Delete table sqlite
SQL
0 vote266 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote300 views1 answer
Can we rollback data that are deleted using DELETE
SQL
1 vote330 views1 answer
How to get the date diff on once field in sql server
SQL
2 votes647 views1 answer
Oracle virtual column
SQL
0 vote295 views1 answer
On update current_timestamp jpa
SQL