34,590
社区成员
发帖
与我相关
我的任务
分享
select * from test where A IN (
select A from test where left(b,2)='00' group by A having count(*)>1)
不知道符合楼主的意思不
SELECT * FROM TEST
WHERE B LIKE '00%'
AND A NOT IN (SELECT A FROM TEST WHERE B NOT LIKE '00%')