How to filter within a Window Function PostgreSQL

Question

I only want to filter in Window function to keep the created_at is null so I don't use WHERE clause previously. Because when I order by created_at desc it will show the null value first.

How to add a filter in this code?

select *, first_value(title) over (partition by product_id order by created_at desc)  as last_title
from t2

I try this not work:

select *, first_value(title) over (partition by product_id order by created_at desc) having (created_at is not null) as last_title
    from t2

user330315 · Accepted Answer · 2020-07-24 05:37:51Z

4

You can sort the NULL values to the end:

first_value(title) over (partition by product_id order by created_at desc nulls last)

answered Jul 24, 2020 at 5:37

user330315

Sign up to request clarification or add additional context in comments.

Comments

Jim Macaulay · Accepted Answer · 2020-07-24 05:34:54Z

0

Please use below condition,

select *, first_value(title) over (partition by product_id order by created_at desc)  
as last_title
from t2 where created_at is not null

answered Jul 24, 2020 at 5:34

Jim Macaulay

5,2515 gold badges32 silver badges60 bronze badges

Collectives™ on Stack Overflow

How to filter within a Window Function PostgreSQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related