1.select * from list where callnumber in (select callnumber from list where group by callnumber having(count(*))>1) order by callnumber
2.SELECT gh
FROM mkgl
GROUP BY gh
HAVING (COUNT(*) > 1)
2.SELECT gh
FROM mkgl
GROUP BY gh
HAVING (COUNT(*) > 1)