Select Distinct a.Functionguid
From Sys_Function a, Sys_Function b
Where 1 = 1
And a.Functionguid = b.Functionguid
And Concat(b.Hierarchycode, ‘.’) Like Concat(a.Hierarchycode, ‘.%’)；

select DISTINCT a.functionGUID
from sys_function a
inner join sys_function b
on CONCAT(b.hierarchyCode,’.’) like CONCAT(a.hierarchyCode,’.%’)
where 1=1;

这个两个SQL是否等价。如果是等价的为什么执行后结果会不一样。不胜感激。