select distinct dictatorid,dictatorlastname, count(dictatorid)
from ichart.transactions where
reportperiod = '201108'
group by dictatorid, dictatorlastname
order by dictatorid ASC;
Can someone tell me how to modify this Oracle query so it only returns records where the total of each distinct dictatorid is greater than 1? I am trying to identify dictatorid's that have been assigned to more than one last name and what last names they are assigned to.