Guest
Ok. Here's the problem: I have a table with duplicate data in a table (see example below). I want to select the record only once instead of the multiple times that it occurs. The problem is that I can't make a specific select statement for each individual number because the table has 70000 records. I hope this is clear.
Field1 Field2
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
3 1
3 2
3 3
To further elaborate, what I want is to select from Field1 1 once, 2 once and 3 once. Is there a way to do this?? Any help would be greatly appreciated.
Field1 Field2
1 1
1 2
1 3
1 4
1 5
2 1
2 2
2 3
3 1
3 2
3 3
To further elaborate, what I want is to select from Field1 1 once, 2 once and 3 once. Is there a way to do this?? Any help would be greatly appreciated.
