Navigation

    MemFireDB论坛

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    1. Home
    2. aaaa果
    A
    • Profile
    • Following 0
    • Followers 0
    • Topics 0
    • Posts 3
    • Best 1
    • Groups 0

    aaaa果

    @aaaa果

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

    aaaa果 Unfollow Follow

    Best posts made by aaaa果

    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      @aaaa果
      1.

      SELECT overlay(attr placing '' from 1 for 7)||substring(attr  from 3 for 2)  from level1;
      
      SELECT '        chart       ' AS chart UNION ALL
      SELECT '--------------------' AS chart UNION ALL
      SELECT chart FROM (
      SELECT concat (LPAD(js :: TEXT,2,'0'),' ','|',' ',COALESCE (MIN (guo),'  '),' ',COALESCE (MIN (qing),'  '),' ',COALESCE (MIN (kuai),'  '),' ',COALESCE (MIN (lei),'  '),' ') AS chart,LPAD(js :: TEXT,2,'0') seNo FROM (
      SELECT ROW_NUMBER () OVER (PARTITION BY attr ORDER BY attr) js,CASE WHEN attr='国' THEN '国' END guo,CASE WHEN attr='庆' THEN '庆' END qing,CASE WHEN attr='快' THEN '快' END kuai,CASE WHEN attr='乐' THEN '乐' END lei FROM level2) tmp GROUP BY js ORDER BY seNo DESC) tmp UNION ALL 
      SELECT '--------------------' UNION ALL 
      SELECT '     2022-10-01     '
      
      posted in 活动
      A
      aaaa果

    Latest posts made by aaaa果

    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      @aaaa果
      1.

      SELECT overlay(attr placing '' from 1 for 7)||substring(attr  from 3 for 2)  from level1;
      
      SELECT '        chart       ' AS chart UNION ALL
      SELECT '--------------------' AS chart UNION ALL
      SELECT chart FROM (
      SELECT concat (LPAD(js :: TEXT,2,'0'),' ','|',' ',COALESCE (MIN (guo),'  '),' ',COALESCE (MIN (qing),'  '),' ',COALESCE (MIN (kuai),'  '),' ',COALESCE (MIN (lei),'  '),' ') AS chart,LPAD(js :: TEXT,2,'0') seNo FROM (
      SELECT ROW_NUMBER () OVER (PARTITION BY attr ORDER BY attr) js,CASE WHEN attr='国' THEN '国' END guo,CASE WHEN attr='庆' THEN '庆' END qing,CASE WHEN attr='快' THEN '快' END kuai,CASE WHEN attr='乐' THEN '乐' END lei FROM level2) tmp GROUP BY js ORDER BY seNo DESC) tmp UNION ALL 
      SELECT '--------------------' UNION ALL 
      SELECT '     2022-10-01     '
      
      posted in 活动
      A
      aaaa果
    • RE: 叮~您有一封国庆SQL闯关邀请函,请查收

      b4d70ada-2674-41db-a6fd-6fb57968ef0a-image.png

      659aae1c-1628-4d12-86d7-2a41ac6b3b96-image.png

      posted in 活动
      A
      aaaa果
    • RE: MemFire创意营总动员-作品提交帖

      昵称】:aaaa果
      【应用名称】:一个简单、高效的评论系统
      【应用简介】:基于Valine适配MemFireCloud的评论系统。
      【仓库地址】:https://github.com/TiannV/Valine
      【体验地址】:https://app.memfiredb.com/cb589ci5g6h46gn9g6q0/
      【插件体验】:https://www.npmjs.com/package/gitbook-plugin-valine-memfire

      posted in 活动
      A
      aaaa果