Re: find duplicate entries (within a group)

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

I would use:

select date, item, warehouse, count(distinct amount)
from file
group by date, item, warehouse
having count(distinct amount) > 1;

And if I wanted to see the amounts I would add listagg(distinct
char(amount), ', ') to the column list.

On Wed, Dec 22, 2021 at 12:43 PM gio.cot via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hi All
>
> I have a table with this data
>
>
>
> Date -Inventory item -Warehouse -Price
>
>
>
> Example
>
> 2021-12-01  K001    001  123,45
>
> 2021-12-01  K001    001  123,45
>
> 2021-12-03  K001    001  223,00     <--
>
> 2021-12-03  K001    001  123,45     <--
>
> 2021-12-10  K001    002  321,45
>
> 2021-12-10  K001    002  321,45
>
> 2021-12-13  X002A 001  500,98     <--
>
> 2021-12-13  X002A 001  555,98     <--
>
>
>
> I would need with Sql, estract the Date -Inventory item -Warehouse of the
> item that in the same day have different price;
>
> result should be:
>
> 2021-12-03  K001    001
>
> 2021-12-13  X002A 001
>
> How can get this result with SQL ? i'm run V7R2
>
> Thanks in advance
>
>
>
>
>
>
>
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com