Navigation

    MemFireDB论坛

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. rui
    R
    • Profile
    • Following 0
    • Followers 1
    • Topics 0
    • Posts 8
    • Best 1
    • Groups 0

    rui

    @rui

    0
    Reputation
    1
    Profile views
    8
    Posts
    1
    Followers
    0
    Following
    Joined Last Online

    rui Unfollow Follow

    Best posts made by rui

    • RE: 咚~1024邀请函,进击的“程序猿”

      我来个花的
      711a8777-61b1-4c42-95c5-b73cc01bcf26-image.png

      
      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;
      
      posted in 活动
      R
      rui

    Latest posts made by rui

    • RE: 咚叮咚~进击的“程序猿”--第三弹

      @pekin 牛!六个核桃还是有用啊!

      posted in 活动
      R
      rui
    • RE: 咚叮咚~进击的“程序猿”--第三弹

      @admin
      难死了啊,难死了啊
      bbfe38f8-c51a-414e-93b0-0e66d03a40d7-image.png

      posted in 活动
      R
      rui
    • RE: 咚叮~进击的“程序猿”--第二弹

      d87b9033-8af9-4880-ac34-0895c2205c60-image.png

      posted in 活动
      R
      rui
    • RE: 咚~1024邀请函,进击的“程序猿”

      我来个花的
      711a8777-61b1-4c42-95c5-b73cc01bcf26-image.png

      
      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;
      
      posted in 活动
      R
      rui
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      @pekin 确实😊 😊

      posted in 活动
      R
      rui
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      @memfiredb-robot 加上了

      更新 新要求

      03f46fdd-6cfa-4b64-9339-d9f6a2d97b80-680c22ff4b5ba1c6b3fa6720f3e91bc.png

      验证

      39fdeb7d-ed08-4626-a1d7-1e73687c27d0-image.png

      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     '
      

      第一题第二题差这么多 我愿称为关了个关

      posted in 活动
      R
      rui
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      根据生成的数据,构造一条SQL,输出结果为:国庆快乐

      select concat(right(attr,2),right(left(attr,4),2)) from level1 ;
      

      验证:

      62cfab20-337f-4ad4-b305-47cb5a4f8cad-image.png

      根据生成的数据,用一条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;
      

      验证:

      9177ec74-a29e-4832-903e-4b58c5b52a3a-image.png

      posted in 活动
      R
      rui
    • RE: MemFire创意营总动员-作品提交帖

      【昵称】:rui2450
      【应用名称】:hongyan
      【应用简介】:hongyan 是一个终端便利的工具集合体,你可以用他来储存/分享文本,上传图片,制作短链接,时间转换时间戳,摩斯加密,获取出网IP,获取本次请求的请求信息....各种功能应有尽有,只要你有基础的java-web知识,还可以自己新增功能哦!
      【仓库地址】:https://gitee.com/rui2450/hongyan
      【演示环境】:https://hongyan.pro/

      posted in 活动
      R
      rui