请教:同一搜索结果内有某一字段内的结果有大量相同,如何把相同的数据合并为一个?

[flyland]

如下语句
SELECT * FROM tb_document WHERE (state = '6') AND (content LIKE '%女孩%') ORDER BY createtime DESC
搜索的title字段会有大量相同
谢谢

[chengangcsdn]

有没有唯一标识字段。

[fesxe]

SELECT distinct * FROM tb_document WHERE (state = '6') AND (content LIKE '%女孩%') ORDER BY createtime DESC

[子陌红尘]

???

SELECT distinct * FROM tb_document WHERE (state = '6') AND (content LIKE '%女孩%') ORDER BY createtime DESC

[chengangcsdn]

楼上的方法是肯定不行的。

[子陌红尘]

SELECT
a.*
FROM
tb_document a
WHERE
a.state = '6'
AND
a.content LIKE '%女孩%'
AND
a.createtime = (select
top 1 createtime
from
tb_document
where
state = a.state
and
content LIKE '%女孩%'
and
title = a.title
order by
createtime)
ORDER BY
a.createtime DESC

[flyland]

找到了

SELECT * FROM aaa WHERE a1 IN(SELECT MIN(a1) FROM aaa GROUP BY a3)

[flyland]

有唯一ID：doc_id字段

[flyland]

大虾，救命啊！