# select site as '数目' from demo group by site having count(*)=1;
说明:count(*)=1 表示筛选出分组后,组内元素个数为1的组。
原文链接:https://www.f2er.com/javaschema/282838.html# select site as '数目' from demo group by site having count(*)=1;
说明:count(*)=1 表示筛选出分组后,组内元素个数为1的组。
原文链接:https://www.f2er.com/javaschema/282838.html