Counting for the same manufacturer...
Posted: Mon Jul 05, 2004 1:38 am
id manufacturer
1 nokia
2 sony ericsson
3 nokia
4 nokia
5 sony ericsson
6 motorola
7 sony ericsson
8 nokia
9 nokia
10 motorola
11 motorola
12 sony ericsson
question is, how can i return the result like the following:
nokia=5
sony erisson=4
motorola=3
i wanna get the total number of all the manufacturers that having the same name in a table... group 'em together and return the total...
tq!
1 nokia
2 sony ericsson
3 nokia
4 nokia
5 sony ericsson
6 motorola
7 sony ericsson
8 nokia
9 nokia
10 motorola
11 motorola
12 sony ericsson
question is, how can i return the result like the following:
nokia=5
sony erisson=4
motorola=3
i wanna get the total number of all the manufacturers that having the same name in a table... group 'em together and return the total...
tq!