Re: find duplicate entries (within a group)

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