| target | start | end |
| ------ | ----- | ---- |
| 1 | NULL | NULL |
| 1 | 100 | NULL |
| 2 | NULL | NULL |
| 2 | NULL | 100 |
我正在嘗試對所描述的表運行查詢，它為我提供了所有target連接行都不匹配的所有值start IS NOT NULL and end IS NULL
所以預期回報是
| target |
| ------ |
| 2 | <-- Has no connected rows where start IS NOT NULL and end IS NULL
我已經嘗試了自我加入，但沒有達到想要的結果
uj5u.com熱心網友回復：
HAVING在子句中使用聚合和條件：
SELECT target
FROM tablename
GROUP BY target
HAVING SUM(start IS NOT NULL AND end IS NULL) = 0;
請參閱演示。
轉載請註明出處，本文鏈接：https://www.uj5u.com/net/493846.html