@pekin 牛!六个核桃还是有用啊!
R
rui 发布的帖子
-
RE: 咚~1024邀请函,进击的“程序猿”
我来个花的
select ' 1111111 000000000 222222222222222 444444444 1::::::1 00:::::::::00 2:::::::::::::::22 4::::::::4 1:::::::1 00:::::::::::::00 2::::::222222:::::2 4:::::::::4 111:::::1 0:::::::000:::::::0 2222222 2:::::2 4::::44::::4 1::::1 0::::::0 0::::::0 2:::::2 4::::4 4::::4 1::::1 0:::::0 0:::::0 2:::::2 4::::4 4::::4 1::::1 0:::::0 0:::::0 2222::::2 4::::4 4::::4 1::::l 0:::::0 000 0:::::0 22222::::::22 4::::444444::::444 1::::l 0:::::0 000 0:::::0 22::::::::222 4::::::::::::::::4 1::::l 0:::::0 0:::::0 2:::::22222 4444444444:::::444 1::::l 0:::::0 0:::::0 2:::::2 4::::4 1::::l 0::::::0 0::::::0 2:::::2 4::::4 111::::::111 0:::::::000:::::::0 2:::::2 222222 4::::4 1::::::::::1 00:::::::::::::00 2::::::2222222:::::2 44::::::44 1::::::::::1 00:::::::::00 2::::::::::::::::::2 4::::::::4 111111111111 000000000 22222222222222222222 4444444444 ' as gqkl;
-
RE: 叮~您有一封国庆SQL闯关邀请函,请查收
@memfiredb-robot 加上了
更新 新要求
验证
code
WITH tmp AS ( SELECT concat(LPAD(rn::text, 2, '0'),' ','|',' ',COALESCE(min(gou),' '),' ',COALESCE(min(qing),' '),' ',COALESCE(min(kuai),' '),' ',COALESCE(min(lei),' '),' ') as chart, LPAD(rn::text, 2, '0'), '|', min(gou) "国", min(qing) "庆", min(kuai) "快", min(lei) "乐" FROM (SELECT row_number() OVER (PARTITION BY attr ORDER BY attr) rn, CASE WHEN attr = '国' THEN '国' END gou, CASE WHEN attr = '庆' THEN '庆' END qing, CASE WHEN attr = '快' THEN '快' END kuai, CASE WHEN attr = '乐' THEN '乐' END lei FROM level2) tmp GROUP BY rn ORDER BY 1 DESC, 2 DESC, 3 DESC, 4 DESC) select ' chart ' as chart union all select '--------------------' as chart union all SELECT chart from tmp union all select '--------------------' union all select ' 2022-10-01 '
第一题第二题差这么多 我愿称为关了个关
-
RE: 叮~您有一封国庆SQL闯关邀请函,请查收
根据生成的数据,构造一条SQL,输出结果为:国庆快乐
select concat(right(attr,2),right(left(attr,4),2)) from level1 ;
验证:
根据生成的数据,用一条SQL语句,生成国庆快乐的柱状图,柱状图所表示的“国庆快乐”的字数要与实际生成的数据保持一致:
WITH d AS ( SELECT row_number() OVER (PARTITION BY attr ORDER BY attr) rn, CASE WHEN attr='国' THEN '国' END gou, CASE WHEN attr='庆' THEN '庆' END qing, CASE WHEN attr='快' THEN '快' END kuai, CASE WHEN attr='乐' THEN '乐' END lei FROM level2 ) SELECT min(gou) "国", min(qing) "庆", min(kuai) "快", min(lei) "乐" FROM d GROUP BY rn ORDER BY 1 DESC, 2 DESC, 3 DESC, 4 DESC;
验证:
-
RE: MemFire创意营总动员-作品提交帖
【昵称】:rui2450
【应用名称】:hongyan
【应用简介】:hongyan 是一个终端便利的工具集合体,你可以用他来储存/分享文本,上传图片,制作短链接,时间转换时间戳,摩斯加密,获取出网IP,获取本次请求的请求信息....各种功能应有尽有,只要你有基础的java-web知识,还可以自己新增功能哦!
【仓库地址】:https://gitee.com/rui2450/hongyan
【演示环境】:https://hongyan.pro/