hi I would like know how to count multiple occurances in a sql query. eg.
row would be: tom, tom , tom, john,pat,pat and this would produce tom 3 john 1 pat 2 I've tried this but I am only gettting 1 back select count(*) from commitCurrent where company =(select distinct company from commitCurrent); Any ideas? I know its not exactly perl but, I have the script written in perl. Thanks in advance Pat -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/
