Forum Moderators: open
F1 F2
1 10
1 12
1 14
2 14
2 12
2 10
In this example records 1-3 have the same F1 value but a different F2. A query contains a WHERE statement that looks for any specific instances of F2 (WHERE F2=10 OR F2=12 OR F2=14).
How can I limit a query so that once it finds the first occurrence of an F1 value (e.g., finds record #1 with F2=10) that it will then ignore that next occurences (e.g., passes over F2=12 and F2=14) and moves on to find the first occurrence of a different F1 value (finds record #4 where F1=2 and F2=14 but passes on next two records)?