Re: How to select unique records in PostgreSQL
| От | David G. Johnston |
|---|---|
| Тема | Re: How to select unique records in PostgreSQL |
| Дата | |
| Msg-id | CAKFQuwbMD+8FvEAx5HUnVS61Sg2YwqhK294G4Pv-7ojKT5Fyig@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: How to select unique records in PostgreSQL (Ron <ronljohnsonjr@gmail.com>) |
| Список | pgsql-general |
On Fri, Nov 25, 2022 at 7:50 AM Ron <ronljohnsonjr@gmail.com> wrote:
Honestly, you do it in PostgreSQL the same way you do it in all the other SQL RDBMSs.
Emphasizing "in PostgreSQL" is nonsensical - it isn't like the OP specified that they know how to do it in some other RDBMS and are trying to convert their knowledge to PostgreSQL.
On 11/24/22 06:01, Rama Krishnan wrote:I want to get the unique wallet_id from this table even it was repeated on multiple occasions I should calculate only once as well as if the wallet_id was calculated on previous month it shouldn't be calculate on next months
You need a subquery to compute the month in which each wallet_id should appear (group by wallet_id with min(date) probably), then you can group on the min(date) column and count the wallets.
David J.
В списке pgsql-general по дате отправления: