查出siteid相同的uv,pv,ip的总数
返回结果 [{'siteid':731,'uv':1,'pv':27,'ip':5},{‘siteid’:495,'uv':5,'pv':36,'ip':3}],
如果还能在加一个排序就好了,按uv,pv,ip任意排序
解决方案
SELECT siteid, sum(uv) AS uv, sum(pv) AS pv, sum(ip) AS ipFROM table_nameGROUP BY siteidORDER BY uv;