clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335834 fiddles created (27454 in the last week).

CREATE TABLE test ([name] varchar(1), [permission] varchar(7)) ; INSERT INTO test ([name], [permission]) VALUES ('A', 'ACPR14'), ('B', 'ACPR14'), ('A', 'ADMI10'), ('B', 'ADMI10'), ('A', 'CMSI06'), ('B', 'CMSI06'), ('A', 'CMSR15'), ('A', 'COPMI01'), ('B', 'COPMI01'), ('B', 'COPMR15') ;
10 rows affected
 hidden batch(es)


select max(name) as name,permission from test group by permission having count(1) = 1
name permission
A CMSR15
B COPMR15
 hidden batch(es)