Re: find duplicate entries (within a group)

[Jimmy Sansi <jsansi@xxxxxxxxx>]

I think... 

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

On 2021-12-22 09:46, gio.cot via RPG400-L 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