tblA
======================
ID NAME AGE ADDRESS
1 AA 11 DDDDD
=======================
查询数据 select count(*) from tblA where name like '%AA%' or AGE like '%11%'
结果是1如何得到 结果2如何一条语句查到有几个字段重复
======================
ID NAME AGE ADDRESS
1 AA 11 DDDDD
=======================
查询数据 select count(*) from tblA where name like '%AA%' or AGE like '%11%'
结果是1如何得到 结果2如何一条语句查到有几个字段重复
(case when AGE like '%11%' then 1 else 0 end) as [重复]
from tbla
select distinct * from T
这样?discinct可以去掉重复的行
select distinct * from T
select (case when name like '%AA%' then 1 else 0 end) +
(case when AGE like '%11%' then 1 else 0 end) as [重复]
from tbla