Re: How to select unique records in PostgreSQL

2022-11-25 Thread David G. Johnston
On Fri, Nov 25, 2022 at 7:50 AM Ron 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 kno

Re: How to select unique records in PostgreSQL

2022-11-25 Thread Ron
Honestly, you do it *in PostgreSQL* the same way you do it in all the other SQL RDBMSs. On 11/24/22 06:01, Rama Krishnan wrote: Hi All, 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

How to select unique records in PostgreSQL

2022-11-24 Thread Rama Krishnan
Hi All, 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 create table student_id ( student_wallet_id int, card_id int,