select pno
  from sp
  group by pno
  having count(*) > 1;
