试试这个：
SELECt xFROM t1ORDER BY CASE WHEN x = 1 THEN 100000001 WHEN x between 2 and 7 THEN 7 - x WHEN x between 8 and ( SELECt max(x) FROM t1 ) - 1 THEN x ELSE 100000000 END
1亿个常量必须大于N。
这是一个简单的演示
试试这个：
SELECt xFROM t1ORDER BY CASE WHEN x = 1 THEN 100000001 WHEN x between 2 and 7 THEN 7 - x WHEN x between 8 and ( SELECt max(x) FROM t1 ) - 1 THEN x ELSE 100000000 END
1亿个常量必须大于N。
这是一个简单的演示
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
