Hi, I have transaction data like below
I need help in writing SQL to get items that are associated with more than one item id (distinct) --
In the above case like i need to list data that is hi-lighted -- Because this is data error.
8366 SXZ4369
73679 SXZ4369
4366 AYZ4369
63679 AYZ4369
Below are table and insert scripts scripts:
create table xx_test1(item_id number, item_number varchar2(80))
insert into xx_test1 values (8366,'SXZ4369');
insert into xx_test1 values (73679,'SXZ4369');
insert into xx_test1 values (430,'NYKZ41');
insert into xx_test1 values (430,'NYKZ41');
insert into xx_test1 values (4366,'AYZ4369');
insert into xx_test1 values (63679,'AYZ4369');
insert into xx_test1 values (530,'BYKZ41');
insert into xx_test1 values (530,'BYKZ41');
Thanks,