guodanhuai的个人博客分享 http://blog.sciencenet.cn/u/guodanhuai GIS,Spatio-temporal Analysis,Spatio-temoporal Data minig

博文

SQL语句

已有 3767 次阅读 2009-12-30 16:16 |个人分类:Technology|系统分类:科研笔记| SQL


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://wap.sciencenet.cn/blog-204718-282629.html

上一篇:Mode of Quality of alignments assessement
下一篇:如何提高记忆力
收藏 IP: .*| 热度|

0

发表评论 评论 (0 个评论)

数据加载中...

Archiver|手机版|科学网 ( 京ICP备07017567号-12 )

GMT+8, 2024-11-1 09:28

Powered by ScienceNet.cn

Copyright © 2007- 中国科学报社

返回顶部