select a.sys_userDiQu,COUNT(*) cc
from wps_systemtj a
inner join
(
select sys_userDiQu ,max(sys_version) as max_sys_version
from wps_systemtj
group by sys_userDiQu
)b
on a.sys_userDiQu = b.sys_userDiQu and
a.sys_version = b.max_sys_version
group by a.sys_userDiQu
from wps_systemtj a
inner join
(
select sys_userDiQu ,max(sys_version) as max_sys_version
from wps_systemtj
group by sys_userDiQu
)b
on a.sys_userDiQu = b.sys_userDiQu and
a.sys_version = b.max_sys_version
group by a.sys_userDiQu
第二:sys_version 这个列的类型不能用max函数
from (
select sys_userDiQu ,max(sys_version)sys_version from wps_systemtj group by sys_userDiQu)a
group by sys_userdiqu