select
 col1被り数,col2被り数,col3被り数,
 code1,code2,code3 
from 
(
select code, count(code) as col1被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a 
group by code ) c1,
(
select code, count(code) as col2被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a 
group by code ) c2,
(
select code, count(code) as col3被り数 from (
select code1 as code from parts union all
select code2 as code from parts union all
select code3 as code from parts ) a 
group by code ) c3,
parts p
where
 p.code1=c1.code and
 p.code2=c2.code and
 p.code3=c3.code 
order by p.no;
 

c2VsZWN0CiBjb2wx6KKr44KK5pWwLGNvbDLooqvjgormlbAsY29sM+iiq+OCiuaVsCwKIGNvZGUxLGNvZGUyLGNvZGUzIApmcm9tIAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wx6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMxLAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wy6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMyLAooCnNlbGVjdCBjb2RlLCBjb3VudChjb2RlKSBhcyBjb2wz6KKr44KK5pWwIGZyb20gKApzZWxlY3QgY29kZTEgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTIgYXMgY29kZSBmcm9tIHBhcnRzIHVuaW9uIGFsbApzZWxlY3QgY29kZTMgYXMgY29kZSBmcm9tIHBhcnRzICkgYSAKZ3JvdXAgYnkgY29kZSApIGMzLApwYXJ0cyBwCndoZXJlCiBwLmNvZGUxPWMxLmNvZGUgYW5kCiBwLmNvZGUyPWMyLmNvZGUgYW5kCiBwLmNvZGUzPWMzLmNvZGUgCm9yZGVyIGJ5IHAubm87Cg==