SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_2052_0_tab
GROUP BY AddUser
结果:
AddUser articleCount
4 1
5 1
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_1033_0_tab
GROUP BY AddUser
结果:
AddUser articleCount
4 1
如何用一条语句让结果加起来:
AddUser articleCount
4 2
5 1
FROM cliterature_2052_0_tab
GROUP BY AddUser
结果:
AddUser articleCount
4 1
5 1
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_1033_0_tab
GROUP BY AddUser
结果:
AddUser articleCount
4 1
如何用一条语句让结果加起来:
AddUser articleCount
4 2
5 1
SQL语句1 union allSQL语句2
FROM(
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_2052_0_tab
GROUP BY AddUser
union all
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_1033_0_tab
GROUP BY AddUser
) T
GROUP BY AddUser
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_1033_0_tab
GROUP BY AddUser
UNION ALL
SELECT AddUser, COUNT(AddUser) AS articleCount
FROM cliterature_2052_0_tab
GROUP BY AddUser