SQL 一条记录的的两个字段值相同与不同的查询答:create table #tb(xm varchar(20),je int,xm01 varchar(20),flag int )goinsert #tbselect '岳恒勇',2401,'刘良福',0 union allselect '刘良福',2833,'岳恒勇',1 union allselect '曹庆波',2489,'曹庆波',0 union allselect '崔世全',2407,'崔世全',1goselect * from #tbwhere exists...