Subject | sql question |
---|---|
Author | Maurizio P. |
Post date | 2006-09-04T21:10:59Z |
hi
i know it is not connected with the newsgroup theme ,
but i would be glad for any suggestion :
how can i find if there are two groups with the same
values , where *ID* is the index of the group ?
for example in the case :
ID F1 F2 F3
5 D F G
5 S J T
10 A C H
10 Z J H
12 A C F
12 A C X
15 D D G
16 A C H
16 Z J H
i have a duplicate with the ID 10 and 16
infact :
10 A C H
10 Z J H
are the same of :
16 A C H
16 Z J H
..mmm... maybe my knowledge of SQL is still poor ,
but today i could not find a good solution .
thanks
bye
Maurizio
[Non-text portions of this message have been removed]
i know it is not connected with the newsgroup theme ,
but i would be glad for any suggestion :
how can i find if there are two groups with the same
values , where *ID* is the index of the group ?
for example in the case :
ID F1 F2 F3
5 D F G
5 S J T
10 A C H
10 Z J H
12 A C F
12 A C X
15 D D G
16 A C H
16 Z J H
i have a duplicate with the ID 10 and 16
infact :
10 A C H
10 Z J H
are the same of :
16 A C H
16 Z J H
..mmm... maybe my knowledge of SQL is still poor ,
but today i could not find a good solution .
thanks
bye
Maurizio
[Non-text portions of this message have been removed]