常用sql---查看一张表里是否有同名员工
select l.st_leader_name ,count(*) count
from li_leader_info l
where l.st_deleted = '0'
group by l.st_leader_name
having count(*)>1
常用sql---查看一张表里是否有同名员工
select l.st_leader_name ,count(*) count
from li_leader_info l
where l.st_deleted = '0'
group by l.st_leader_name
having count(*)>1