不显示删除回复显示所有回复显示星级回复显示得分回复 Group后，查询至少包含某一项以上的数据。如何查询？[

select userid from tb1 b where gup='C' and 

exists(select null from tb1 a where a.userid=b.userid and gup<>'C')

select userid

from tab a

where 数据项='c'

and exists (

 select 1 from tab

 where userid = a.userid

 and 数据项<>'c'

 )

group by userid