select single count in isolation

Hi, @ricard888

Yet another way:

SELECT    rcs.*
FROM	  table1 rcs
LEFT JOIN table1 oth  ON  oth.service_id = rcs.service_id
   	  	      AND oth.ROWID      <> rcs.ROWID
WHERE     rcs.charge_type = 'RCs'
AND	  oth.charge_type IS NULL
ORDER BY  rcs.service_id -- or whatever you want
;