henry0 - 4:32 pm on Mar 10, 2011 (gmt 0)

I cannot come with a concept
Case:
Table with many rows, among fields are A, B, C,
each are int and contain a value from 1 to 5
example id 333 when ordered by int value comes with a result aqual at B, C, A
and here is my quandary how could I match/select all rows where the same result B, C, A as id 333 exists?

I mean doing it in a consise way and not resource "gobling".

thanks