Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: (OT) Exclusion selection on DBIby moritz (Cardinal) |
on Jan 25, 2008 at 11:47 UTC ( [id://664271]=note: print w/replies, xml ) | Need Help?? |
Untested:
I don't know if that's standard sql, but it should work with MySQL Update: I just tested something similar with mysql 5, and the alias doesn't seem to be necessary, so just SELECT name, color FROM fruit GROUP BY name HAVING COUNT(name) >= 2 ORDER BY fruit;
In Section
Seekers of Perl Wisdom
|
|