在项目中遇到:
select pu.id,pl.ruleid from permissionruleworkflowbase pu left join permissionlinkworkflowbase pl on pu.id = pl.ruleid
的记录条数居然大于
select pu.id,pl.ruleid from permissionruleworkflowbase pu
据了解,副表里的关联值如果很多是重复的话会有这种现象。
另外这两句的作用是一样的
select count(*) from (select * from permissionlinkworkflowbase group by ruleid having count(ruleid)=1)
select count(*) from (select DISTINCT ruleid from permissionlinkworkflowbase)