Re: generating the average 6 months spend excluding first orders
| От | David G Johnston |
|---|---|
| Тема | Re: generating the average 6 months spend excluding first orders |
| Дата | |
| Msg-id | CAKFQuwbyE1=iByxRiUkeBZ474_aGEBgjaKZwqQUHLOf91OT2Dg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: generating the average 6 months spend excluding first orders (Ron256 <ejaluronaldlee@gmail.com>) |
| Ответы |
Re: generating the average 6 months spend excluding first orders
|
| Список | pgsql-sql |
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?
Unless you tell us what you think the correct result should be it is impossible to know whether it is the result or your expectation that is incorrect.
It would also help to modify your query instead of simply saying "when you use this persistent_key_str = '...'"; show us the query that makes use of that detail.
David J.
View this message in context: Re: generating the average 6 months spend excluding first orders
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
В списке pgsql-sql по дате отправления: