- 博客(2)
- 收藏
- 关注
原创 postgresql行转列
创建表CREATE TABLE "public"."tb_user" ( "id" int4 NOT NULL, "name" varchar(255) COLLATE "pg_catalog"."default", "age" int4, "sex" varchar(255) COLLATE "pg_catalog"."default");INSERT INTO "public"."tb_user" VALUES (1, '张三', 15, '男');INSERT INTO "p
2020-12-29 16:36:49 966
原创 sql实现小数位小于0.25舍弃,0.25-0.75等于0.5,大于0.75进1
sql实现小数位小于0.25舍弃,0.25-0.75等于0.5,大于0.75进1select case when 232*0.05 %1 <0.25 then floor(232*0.05) when 232*0.05 %1 >0.75 then ceil(232*0.05) else floor(232*0.05)+0.5 end
2020-12-29 15:22:40 803
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人