Help needed: Retrieve only rows where numbers are concurrent

From: KrasS <ballonier_at_mousehut.com>
Date: 11 Jul 2002 02:05:14 -0700
Message-ID: <31113d1d.0207110105.1bb1e628@posting.google.com>

Hi,

I have the following (temporary) table:

trainer_id room_id slot_id
----------- ------- -----------

1           1       147         
1           1       148         
1           1       149         
5           1       147         
5           1       148         
5           1       149         
7           1       147         
7           1       148         
7           1       149         
11          1       148         
1           2       147         
1           2       148         
1           2       149

etc...

How should I query this table to retrieve a list where: trainer_id and room_id have 3 concurrent slot_id available, like:

trainer_id room_id slot_id
----------- ------- -----------

1           1       147         
1           1       148         
1           1       149

Eventually, I will use a variable to define the number of required concurrent slots, but I don't think that will change the structure of the query anyway.

Thanks for helping me out!

Kind regards,

John Bakta Received on Thu Jul 11 2002 - 04:05:14 CDT