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', 'Barcelona' from dual
union all
select 'Apple', 'Moscow' 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', 'Cairo' from dual
union all
select 'Orange', 'Cairo' from dual
union all
select 'Grapes', 'Berlin' from dual
union all
select 'Rice', 'Manila' from dual
10 rows affected

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


ITEM
DESTINATION
CNT


Apple
Barcelona
5

Apple
London
5

Apple
Moscow
5

Apple
Paris
5

Apple
Rome
5


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


ITEM
DESTINATION
CNT


Apple
Barcelona
5

Apple
London
5

Apple
Moscow
5

Apple
Paris
5

Apple
Rome
5

ITEM	DESTINATION	CNT
Apple	Barcelona	5
Apple	London	5
Apple	Moscow	5
Apple	Paris	5
Apple	Rome	5