SQL 编写查询某个时间段的数据:
SELECT count(*) FROM "public"."ac_demand" as tt WHERE to_char(tt.addtime,'yyyy-mm-dd') <= '2016-08-31'
当pid重复时,只取其中一条数据
select DISTINCT pid from as_businesses GROUP BY pid;
查询某一字段不为空的记录
select * from ac_service_log t WHERE t.ogcid is not null;
将一个表中的某一字段复制到另一个表中的某一字段
UPDATE sp_dict_product set score=sp_dict_product_test.score FROM sp_dict_product_test WHERE sp_dict_product."id"=sp_dict_product_test."id"
将多条记录合并为一个字符串,用逗号隔开:
select array_to_string(array(select id from table_xxx),',');
将一个字符串且分为多条记录
select regexp_split_to_table('1,2,3,4,5,6,7',',') as id;