您知道如何从字段1中获取在字段2中不包含0值的值吗? 例如,我只想从下表中 Select "bbb"和"ddd":
Field 1 | Field 2 |
---|---|
AAA | 1 |
AAA | 2 |
AAA | 0 |
BBB | 1 |
BBB | 2 |
CCC | 0 |
CCC | 2 |
DDD | 3 |
(BBB和DDD在字段2中不包含零值)
您知道如何从字段1中获取在字段2中不包含0值的值吗? 例如,我只想从下表中 Select "bbb"和"ddd":
Field 1 | Field 2 |
---|---|
AAA | 1 |
AAA | 2 |
AAA | 0 |
BBB | 1 |
BBB | 2 |
CCC | 0 |
CCC | 2 |
DDD | 3 |
(BBB和DDD在字段2中不包含零值)
我可以想到两种方法来实现这一点:
SELECT DISTINCT Field1
FROM your_table
WHERE Field1 NOT IN (
SELECT Field1
FROM your_table
WHERE Field2 = 0
);
group by
and having
SELECT Field1
FROM your_table
GROUP BY Field1
HAVING SUM(CASE WHEN Field2 = 0 THEN 1 ELSE 0 END) = 0;
100