note
mpeppler
Obviously not a perl question, however:
<code>
select fruit, color
from fruit_table
where fruit in (select fruit
from fruit_table
group by fruit
having count(*) > 1)
order by fruit
</code>
should normally work (untested, though).
<p>
Michael
<p>
Update: [moritz]'s solution is cleaner (and probably faster, if it matters), but has an additional column in the result set (which probably doesn't matter, so a better solution overall :-)
664269
664269