Locating uniques that occur less than n times.

Hello,
I'm a relatively new RDB user and am attempting to construct a
(re)usable query to return entries that occur on a table less than _n_
times. eg. I have 500K product numbers across 6 columns (stores) and i
need to find all the entries that occur in less than all 6 stores.
This may be a really simple query, finding single entry items is no
problem, but im having trouble finding _n_ uniques (5 or less).
Thanks!!

thorassic5@gmail.com wrote:
> Hello,
> I'm a relatively new RDB user and am attempting to construct a
> (re)usable query to return entries that occur on a table less than _n_
> times. eg. I have 500K product numbers across 6 columns (stores) and i
> need to find all the entries that occur in less than all 6 stores.
> This may be a really simple query, finding single entry items is no
> problem, but im having trouble finding _n_ uniques (5 or less).
> Thanks!!

Sounds like you have the wrong structure for your table.

Care to post the schema and maybe some sample data.