sql server 里面的包含如何写

--> 测试数据：[test]if object_id('[test]') is not null drop table [test]create table [test]([字段A] varchar(1),[字段B] varchar(4))insert [test]select 'A','结束' union allselect 'A','开始' union allselect 'A','开始' union allselect 'A','开始' union allselect 'A','开始' union allselect 'A','开始' union allselect 'B','开始' union allselect 'B','开始' union allselect 'B','开始' union allselect 'C','开始' union allselect 'C','开始' union allselect 'C','开始' union allselect 'C','开始'select * from test awhere not exists(select 1 from test b    where a.字段A=b.字段A and b.字段B='结束')/*字段A    字段BB    开始B    开始B    开始C    开始C    开始C    开始C    开始*/