I have a database with data as follows:
ID STATUS
12345 O
12345 O
54321 C
54321 O
45678 C
45678 O
78901 C
78901 C
I would like to know a query that will allow me to pull IDs that, in this case, have the same status in each occurence. For example, I would need to return 12345 since both records are STATUS = O and 78901 since both records are STATUS = C
Thanks!!
