Thread Abfrage nicht normalisierter db
(5 answers)
Opened by esskar at 2008-08-09 02:58
[sql]select
username, sum( if(attribute='type' and value='reject',1,0) ) as rejected from foo group by username having rejected = 0;[/sql] das geht bei mir... Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. -- Damian Conway in "Perl Best Practices"
lesen: Wie frage ich & perlintro brian's Leitfaden für jedes Perl-Problem |