以上数据
我搜索的时候 比如 title like ‘%关键字%’
相同的 memberid 我只要一条 这一条是 相同的memberid 里时间最新的也就是这个意思
select memberid from table where title like '%感冒%' group by memberid
按照 memberid 分组 搜索 感冒关键字
然后按照这个 分组出来的 memberid 比较 假如 以上查询出 memberid 2 5 11 34
剩下的操作就是
select top 1 * from table where memberid = 2 order by times desc
select top 1 * from table where memberid = 5 order by times desc
select top 1 * from table where memberid = 11 order by times desc
select top 1 * from table where memberid = 34 order by times desc 我要的是这些结果的和
说的明白了吧。
谢谢各位没分了
select *
from [table] t
where not exists (select 1 from [table] where memberid=t.memberid and title like ‘%关键字%’and createtime>t.createtime)
and title like ‘%关键字%’
select *
from [table] t
where not exists (select 1 from [table] where memberid=t.memberid and title like '%关键字%' and createtime>t.createtime)
and title like '%关键字%'
*
from
[table] t
where
createtime=(select max(createtime) from [table] where memberid=t.memberid and title like '%关键字%')
and
title like '%关键字%'
高手能不能留个QQ我加你 我QQ:10047588