Jump to content

Archived

This topic is now archived and is closed to further replies.

sanlike

COUNT NUMBER OF TIMES A VALUE OCCURES IN ARRAY

Recommended Posts

i HAVE FOLLOWING VALUES IN FEED TABLE

 

a1a    a1b    a1c    a1d ......

7         8        7         7

8         9        8         8

9         7        7         8

7        8        10        9

6         4        6         7

7        8         8        5

9        7         7        6

 

This in an array ( select a1a,a1b,a1c,a1d from feed where .....)

 

1) I want to know how many times each values has occured in the array ( eg:  7 occured 10 times, 8 occured 8 times)

 

2) How many 7's, 8's, 9's  are there in a1a,   howmany .....in a1b

 

Number of times each values occured OVERALL in array   as  well as also under each head

 

Please help

Share this post


Link to post
Share on other sites

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.