Question

asp如何将表内某一个字段的相同数据筛选后只显示一个

asp如何将表内某一个字段的相同数据筛选后只显示一个

Answer 1

1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断
select * from people
where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1)

例二：
select * from testtable
where numeber in (select number from people group by number having count(number) > 1 )
可以查出testtable表中number相同的记录

具体可以参考下我这篇文章，不清楚的也可以后面留言：http://www.ttasp.net/article/3/14/201405/115.html

Answer 2

你的意思就是 不显示 重复数据吧？
select distinct 字段 from table

Answer 3

select distinct 某字段,字段1,字段2 from table where 字段x=条件x order by id desc

Answer 4

select distinct strname from table