var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Need count and subselects
i use mysql 4.0.20 and have the following problem:
I have a column with names and want to extract all names which are lets say 3 times in this column. See
In this case mysql shoud output foo and bla, but how to do this??
I tried some combinations of count and something like subselects, but no success.
Could anybody help me please? It drives me crazy.
hmm, does mysql support having?
group by names
having count(*) = 3
yea it does,
i will give it a try, but not sure to get it working.
Thanks, bye, b52
YES it works!
SELECT KNAME FROM AUFTRAG LEFT JOIN KUNDE ON KNR=AKNR GROUP by KNAME HAVING COUNT(*) =3
Thank you , bye, b52