22,209
社区成员
发帖
与我相关
我的任务
分享
select distinct id from tb where Keywords='词一' or Keywords='词二'
select id from
(
select distinct id from tb where Keywords='词一'
union all
select distinct id from tb where Keywords='词二'
) t
group by id having count(id) = 2
select id from tab
where Keywords='词一' OR Keywords='词二'
group by id
order by count(Keywords) desc