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.