Home -> Usenet -> comp.databases.theory -> Help needed: Retrieve only rows where numbers are concurrent

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_at_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 - 11:05:14 CEST












Original text of this message