Hi,
i have a table with 15 fields. In this table there are two fields
ID value
1 A
1 B
2 C
3 D
2 A
2 B
4 A
5 A
Now i want to select Ids which having more than two distinct values
ID Value
1 A
1 B
2 A
2 B
2 C
how can i create query for this..
i have a table with 15 fields. In this table there are two fields
ID value
1 A
1 B
2 C
3 D
2 A
2 B
4 A
5 A
Now i want to select Ids which having more than two distinct values
ID Value
1 A
1 B
2 A
2 B
2 C
how can i create query for this..