select dept3_.DEPT_NAME as col_0_0_,
item1_.IT_NAME as col_1_0_,
account2_.EMP_ID as col_2_0_,
account2_.USER_NAME as col_3_0_
from MANHAUR manhaur0_
inner join ITEM item1_ on manhaur0_.IT_ID = item1_.ID
inner join ACCOUNT account2_ on manhaur0_.USER_ID = account2_.ID
inner join DEPT dept3_ on account2_.DEPT_ID = dept3_.ID
where manhaur0_.STATUS <> '0'
group by dept3_.DEPT_NAME,
item1_.IT_NAME,
account2_.EMP_ID,
account2_.USER_NAME
得到的结果是这样的
1 产品四部 呼叫中心 070 a
2 产品四部 呼叫中心 077 b
3 产品一部 用户管理 059 c
4 产品一部 用户管理 067 d
5 产品一部 用户管理 068 e
6 产品一部 用户管理 087 f
如何才能求出得到结果的行数呢?(就是想得出到结果为6)
item1_.IT_NAME as col_1_0_,
account2_.EMP_ID as col_2_0_,
account2_.USER_NAME as col_3_0_
from MANHAUR manhaur0_
inner join ITEM item1_ on manhaur0_.IT_ID = item1_.ID
inner join ACCOUNT account2_ on manhaur0_.USER_ID = account2_.ID
inner join DEPT dept3_ on account2_.DEPT_ID = dept3_.ID
where manhaur0_.STATUS <> '0'
group by dept3_.DEPT_NAME,
item1_.IT_NAME,
account2_.EMP_ID,
account2_.USER_NAME
得到的结果是这样的
1 产品四部 呼叫中心 070 a
2 产品四部 呼叫中心 077 b
3 产品一部 用户管理 059 c
4 产品一部 用户管理 067 d
5 产品一部 用户管理 068 e
6 产品一部 用户管理 087 f
如何才能求出得到结果的行数呢?(就是想得出到结果为6)
from (select dept3_.DEPT_NAME as col_0_0_,
item1_.IT_NAME as col_1_0_,
account2_.EMP_ID as col_2_0_,
account2_.USER_NAME as col_3_0_
from MANHAUR manhaur0_
inner join ITEM item1_ on manhaur0_.IT_ID = item1_.ID
inner join ACCOUNT account2_ on manhaur0_.USER_ID = account2_.ID
inner join DEPT dept3_ on account2_.DEPT_ID = dept3_.ID
where manhaur0_.STATUS <> '0'
group by dept3_.DEPT_NAME,
item1_.IT_NAME,
account2_.EMP_ID,
account2_.USER_NAME
)