这样写select 后面的有什么错误,在其他数据库里面写 的时候
#查询54789625的好友的
#分组查询错误:多对一,无意义#
SELECT bi.Province,COUNT(bi.Province) AS 总人数
FROM BaseInfo AS bi
JOIN Relation AS re ON bi.QQID
=re.RelationQQID
WHERE re.QQID
=54789625 AND re.RelationStatus=0
GROUP BY Province #desc #分组查询#
ORDER BY COUNT(bi.Province) DESC #排序#