08 2022 档案
摘要：SELECT st_x(cast(point(100, 200) as geometry)) SELECT st_y(cast(point(100, 200) as geometry)) 搜索 复制
阅读全文
摘要：-- 截取指定字符最后出现的前半部分select reverse(substr(reverse('/C107341723B_145404/01/0_20220802_145505552.jpg'),position('/' in reverse('/C107341723B_145404/01/0_2
阅读全文
摘要：1、建表语句 DROP TABLE IF EXISTS "public"."json_param";CREATE TABLE "public"."json_param" ( "id" int4 NOT NULL, "json" text COLLATE "pg_catalog"."default")
阅读全文
摘要：UPDATE road_jcpd_record a set road_lst_id = b.id from road_lst b where b.road_code = a.road_code and a.road_code = '' 搜索 复制
阅读全文
摘要：CREATE OR REPLACE FUNCTION "public"."generate_road_list_id_to_jcpddas"("road_code_param" varchar) RETURNS "pg_catalog"."int4" AS $BODY$declare returnv
阅读全文
摘要：SELECT u.gender , count(*) FILTER (WHERE u.age > 20 and u.name like '%张') AS playedFROM users uGROUP BY u.gender; 搜索 复制
阅读全文
摘要：SELECT * from ( SELECT ROW_NUMBER() OVER(PARTITION by wj ORDER BY px desc)idx,px,wj from table ) ord where ord.idx = 1 wj ：关联外键 px ：排序字段 ROW_NUMBER：该函
阅读全文
