I have an issue with a SQL query. I have a table as below
EMPLOYEE_ID | STATUS
--------------------
123 C
234 S
456 S
123 C
789 S
EMPLOYEE_ID
C
I'm not Oracle, but see if you can use this.
Select Employee_ID
From table
Where Status = 'C'
Group By Employee_ID
Having Count(Status) < 2