SELECT * FROM tba WHERE a NOT IN (select a from tba AS A where b = '结束')

------解决方案--------------------

SQL code
select * from tb t where not exists(select 1 from tb where 字段a=t.字段a and b='结束')