Items in list which have >=100 or more on list
Code:
select item,COUNT(item) as numbers_of_replicates from merchantlist group by item
Code:
itemid , replicates
16598,297
13006,295
13009,247
13008,245
13005,211
13007,202
16580,195
13002,193
13032,168
10028,166
17005,166
13003,165
7001,161
13087,146
13018,138
13004,137
13040,134
13039,133
5019,130
13100,128
10024,126
13101,123
5013,123
16599,122
10019,119
6011,119
10020,118
6018,117
13068,117
10029,114
17908,114
13031,114
10026,113
5021,111
5020,111
13033,110
17001,110
13085,109
13030,106
13034,104
13015,104
10022,103
13014,102
1001,102
6012,102
5016,102
10015,101
GeorgeS