您可以使用聚合和 having :

select id
from t
group by id
having min(somevar) > 0;

这是假设 somevar 从不消极。如果这是可能的，那么您可以使用稍微详细一点的：

select id
from t
group by id
having sum(case when somevar = 0 then 1 else 0 end) = 0;

带有count或sum聚合的用例语句，使用 having :

select ID  
  from
      ( 
       select ID, count(case when SomeVar=0 then 1 end) cnt
         from mytable
        group by ID having count(case when SomeVar=0 then 1 end) = 0 
      ) s
;

我通常尝试避免子查询，但在这种情况下可以使用一个。执行相同的groupby，并检查id是否不在somevar为0的id的子查询中。在这种情况下，distinct将执行相同的操作，并且效率更高，因此我将首先执行以下操作：

SELECT DISTINCT ID
FROM [table_name]
WHERE ID NOT IN (
    SELECT ID FROM [table_name] WHERE SomeVar = 0
);

如果你想通过分组方式获得其他信息：

SELECT ID, max(SomeVar), count(*), sum(SomeVar)
FROM [table_name]
WHERE ID NOT IN (
    SELECT ID FROM [table_name] WHERE SomeVar = 0
)
GROUP BY ID;