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.