寻找大致相同的记录

[好帅的一条鱼]

表中一字段ID，数值长度大于等于10，，寻找前八个数值相同的记录。。。。。

[liangCK]

SELECT *
FROM tb AS t
WHERE EXISTS(SELECT *
             FROM tb
             WHERE LEFT(ID,8)=LEFT(t.ID,8))

[liangCK]

SELECT *
FROM tb AS t
WHERE EXISTS(SELECT *
             FROM tb
             WHERE LEFT(ID,8)=LEFT(t.ID,8)
                   AND ID!=t.ID)

[pt1314917]

SELECT * FROM tb a WHERE EXISTS(SELECT * FROM tb WHERE LEFT(ID,8)=LEFT(t.ID,8))

[lyyrw]

select top 8 * from table where id in (select id from table group by id having count(id)>=8)

[好帅的一条鱼]

谢谢大家，，解决了