SELECT DISTINCT CITY
FROM STATION
WHERE MOD(ID, 2) = 0

你可以试试这个查询：

SELECT DISTINCT CITY FROM STATION WHERE (ID % 2) = 0

对于DB2：

SELECT DISTINCT CITY 
FROM STATION
WHERE MOD(ID, 2) = 0;

对于Oracle：

SELECT DISTINCT CITY 
FROM STATION
WHERE MOD(ID, 2) = 0;

MySQL：

SELECT DISTINCT CITY 
FROM STATION
WHERE MOD(ID, 2) = 0;

或者...

SELECT DISTINCT CITY 
FROM STATION
WHERE ID%2=0;

对于MSSQL：

SELECT DISTINCT CITY 
FROM STATION
WHERE ID%2=0;

SELECT DISTINCT CITY FROM STATION WHERE (ID % 2) = 0;

• DISTINCT用于不允许重复，
• (Id % 2)告诉SQL将Id除以2并返回余数。
• 由于我们只查找偶数值，因此将其设置为= 0，如2%2=0，4%2=0等。
• 如果我们在寻找奇数的Id s，我们会使用= 1，因为当奇数除以2时，总是有1的余数。

MYSQL：

SELECT DISTINCT CITY FROM STATION WHERE (ID % 2)=0;

ORACLE：

SELECT DISTINCT CITY FROM STATION WHERE MOD(ID, 2)=0;

如果问题类似于“从仅具有偶数ID号的车站查询城市名称列表”，则答案为

select CITY from station where ID % 2 = 0;

但由于进一步的标准，如“但必须排除重复从你的答案。”你的答案应该是

select DISTINCT CITY from station where ID % 2 = 0;

我建议另一个解决方案：

SELECT DISTINCT CITY
    FROM STATION
    WHERE ID LIKE '%0' OR ID LIKE '%2' OR ID LIKE '%4' OR ID LIKE '%6' OR ID LIKE '%8';

在MSSQL中：

SELECT CITY
FROM STATION
WHERE (ID % 2) = 0
GROUP BY CITY

SQL Server使用带有case-when语句的子查询：-

SELECT DISTINCT CITY FROM STATION WHERE ID IN (SELECT 
                                               CASE
                                                   WHEN ABS(ID%2) = 0 THEN ID
                                               END 
                                               FROM STATION);