查询按大小写选择不同顺序时出现问题

Question

在以下问题的帮助下，我学会了如何使用SELECT Distince和ORDER BY:
如何在相同的SELECT语句中使用Distince和ORDER BY？

我从以下问题中学会了使用按大小写排序:
如何首先返回具有特定值的行？

但我有一个很难写的查询:

我有一个表customer和一个列name，我想要获得客户的所有indist名称，并且我想首先找到名称“hamza”。

SELECT DISTINCT "CUSTOMER"."NAME",
    Max("CUSTOMER"."NAME")
FROM "CUSTOMER"
WHERE
    "CUSTOMER".id >= 2
GROUP BY "CUSTOMER"."NAME"
ORDER BY CASE WHEN ("CUSTOMER"."NAME" = 'HAMZA' ) THEN 1 ELSE 2 END

错误:

错误：对于SELECT DISTINCT,ORDER BY表达式必须出现在SELECT List
第15行：ORDER BY CASE WHEN（“Customer”.“name”=“Hamza”）THEN 1

编辑

SELECT "CUSTOMER"."NAME", -- distinct keyword removed here
    Max("CUSTOMER"."NAME")
FROM "CUSTOMER"
WHERE
    "CUSTOMER".id >= 2
GROUP BY "CUSTOMER"."NAME"
ORDER BY
CASE WHEN ("CUSTOMER"."NAME" = 'HAMZA' ) THEN 1 ELSE 2 END,
CASE WHEN ("CUSTOMER"."NAME" = 'GIORNO' ) THEN 1 ELSE 2 END

Answer 1

分组将确保您获得不同的客户名称。只要去掉这个修饰符，你就应该没事了：

SELECT "CUSTOMER"."NAME", -- distinct keyword removed here
    Max("CUSTOMER"."NAME")
FROM "CUSTOMER"
WHERE
    "CUSTOMER".id >= 2
GROUP BY "CUSTOMER"."NAME"
ORDER BY CASE WHEN ("CUSTOMER"."NAME" = 'HAMZA' ) THEN 1 ELSE 2 END