重复性校验---
SELECT
sum(
IF (
UPPER(t. NAME) = UPPER(‘222‘),
1,
0
)
) NAME
FROM
position t
WHERE
(UPPER(t. NAME) = UPPER(‘222‘))
and t.parent_id=‘154edf4c62d411e7a0b70024e8495df3‘
and t.name_type=3
and t.del_status=1
AND t.id != ‘dd65d714647011e792040024e8495df3‘
原文：http://www.cnblogs.com/mjbenkyo/p/7281148.html