SELECT UserId,COUNT(1) AS num FROM product GROUP BY userId ORDER BY num desc
这条是在product 表获取每个用户有多少个产品第二条:select count(1) from subProduct where userId=上面的userId想要的最终结果是:用户ID 产品总数 SUB的总数
有没有一条SQL语句能解决?
这条是在product 表获取每个用户有多少个产品第二条:select count(1) from subProduct where userId=上面的userId想要的最终结果是:用户ID 产品总数 SUB的总数
有没有一条SQL语句能解决?
(select count(1) from subProduct where userId=A.userId) FROM product A GROUP BY userId ORDER BY num desc
FROM product A
GROUP BY userId
ORDER BY num desc