select * from
(select TARGET_ID,KEYRESULTS_NOWVALUE
from KTKJ_TARGET_KEYRESULTS
group by TARGET_ID,KEYRESULTS_NOWVALUE) a
group by TARGET_ID
having count(TARGET_ID)=1 and KEYRESULTS_NOWVALUE = 0
如何查询相同 ID下某一列全部相同的 sql 语句怎么写?
最新推荐文章于 2023-01-09 17:05:57 发布