SELECT
a.id,
a.xxx,
count(
DISTINCT concat(o.o_id, o.create_time)
) as target
FROM
yyyyy a
JOIN zzzz o ON o.oid = a.vid
GROUP BY
a.id,
a.xxx
本例子中是两个字段确定一条数据,统计数量过程中对结果(o.o_id, o.create_time)去重
SELECT
a.id,
a.xxx,
count(
DISTINCT concat(o.o_id, o.create_time)
) as target
FROM
yyyyy a
JOIN zzzz o ON o.oid = a.vid
GROUP BY
a.id,
a.xxx
本例子中是两个字段确定一条数据,统计数量过程中对结果(o.o_id, o.create_time)去重