My table has 2 to 3 test results for each id. I want to get the id that have only one record where Result='Repeat'
id Results TestNo
123 repeat Test 1
125 Repeat Test 1
123 Negative Test 2
123 Negative Test 3
127 Positive Test 1
128 Repeat Test 1
In the above case I want to pull 125 and 128 records
I want to pull the list of all the Repeat results for testing which were not test again.
Not sure if my question is clear.
Will the Self query work?
Also is there a a way to query the table to get row counts on the spot
thank you