Re: generating the average 6 months spend excluding first orders

David,

Please I need your help on getting the first time buyer.

I am using the following query but I am getting incorrect results

with cte as
(select *,
row_number() OVER( partition by persistent_key_str order by
ord_submitted_date) RN
from orders )
select *
from cte where rn = 1

When you use this persistent_key_str = '01000217334' I get incorrect
results.

How can I resolve this?

Thanks,

Ron

--
View this message in context: http://postgresql.nabble.com/generating-the-average-6-months-spend-excluding-first-orders-tp5828253p5828381.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.