select code,name, org_lon,org_lat,sum(bytes) as bytes,sum(visitors) as visitors from "public"."sdb_ac"
 where code in (select DISTINCT code from  "public"."sdb_ac")
 group by code,name, org_lon,org_lat
 ;

转载本文请联系原作者获取授权，同时请注明本文来自郭旦怀科学网博客。
链接地址：https://blog.sciencenet.cn/blog-204718-282629.html

上一篇：Mode of Quality of alignments assessement
下一篇：如何提高记忆力