Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table ProductsTable (Item, Destination) as
select 'Apple', 'Rome' from dual
union all
select 'Apple', 'Paris' from dual
union all
select 'Apple', 'London' from dual
union all
select 'Orange', 'Cairo' from dual
union all
select 'Orange', 'New York' from dual
union all
select 'Orange', 'Cape Town' from dual
union all
select 'Grapes', 'Berlin' from dual
union all
select 'Rice', 'Manila' from dual
8 rows affected

SELECT PrdTbl.Item,PrdTbl.Destination,PrdTbl2.cnt
FROM ProductsTable PrdTbl
JOIN
(
SELECT Item,count(*) cnt FROM ProductsTable
GROUP BY Item
HAVING COUNT(*) > 1
) PrdTbl2 ON PrdTbl.Item = PrdTbl2.Item
ORDER BY PrdTbl.Item;


ITEM
DESTINATION
CNT


Apple
London
3

Apple
Paris
3

Apple
Rome
3

Orange
Cairo
3

Orange
Cape Town
3

Orange
New York
3


SELECT Item, Destination, cnt
FROM (
  SELECT Item, Destination, count(*) OVER (PARTITION BY Item) as cnt
  FROM ProductsTable
)
WHERE cnt > 1
ORDER BY Item;


ITEM
DESTINATION
CNT


Apple
Paris
3

Apple
Rome
3

Apple
London
3

Orange
Cape Town
3

Orange
New York
3

Orange
Cairo
3

ITEM	DESTINATION	CNT
Apple	London	3
Apple	Paris	3
Apple	Rome	3
Orange	Cairo	3
Orange	Cape Town	3
Orange	New York	3