Supercool! That worked to get the multiple (> 2) records located.
Thanks for you help!!! On 7/29/05, Deanna Schneider <[EMAIL PROTECTED]> wrote: > Try this. > > SELECT contentid > FROM mytable > GROUP BY contentid > Having count(contentid) = 2 > > > > On 7/28/05, William Bowen <[EMAIL PROTECTED]> wrote: > > there must be a way to do this but I just can't think of it... > > > > I've got a Boundary table that holds the list of tree nodes for a web site. > > > > there are two columns. content_ID and boundary > > > > now, for each "record" in the tree there are two entries, a beginning > > boundary and an ending boundary > > > > so record 1001 would look like this: > > content_ID, Boundary > > 1001 1 > > 1001 2 > > > > if there are "child" records to 1001 they'll look like this: > > > > 1001 1 > > 1002 2 > > 1002 3 > > 1001 4 > > > > okay, so I recently discovered a problem. sometimes when a content_ID > > is inserted to "records" will be created. > > > > so the above will look like this: > > > > 1001 1 > > 1002 2 > > 1002 3 > > 1002 45 > > 1002 46 > > 1001 4 > > > > in the table though, the mis-inserted records are nver close together, more > > like > > > > 1002 2 > > 1002 3 > > 1002 3456 > > 1002 3457 > > > > if I query for content_ID = 1002 > > > > So, my question: > > > > is there a way that I can retrieve all content_IDs from the table that > > occur more than twice without having to check by querying against a > > specific content ID? > > > > the results I am looking for would be something like: > > > > 1002 2 > > 1002 3 > > 1002 3456 > > 1002 3457 > > 1005 72 > > 1005 73 > > 1005 990 > > 1005 991 > > > > It's probably pretty simple but I just can't seem to make it click... > > > > TIA! > > -- > > will > > > > > > "If my life weren't funny, it would just be true; > > and that would just be unacceptable." > > - Carrie Fisher > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get help! RoboHelp http://www.houseoffusion.com/banners/view.cfm?bannerid=58 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:167242 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
