求sql显示（查询）不重复数据命令 必须有唯一标识列才能过滤重复，下面给你个思路：生成唯一id列：select id=identity(1，1)，bianhao、name、jiage、chandi、shuliang into#tmp_tb from 表1查询显示name不重复的所有数据：select*from#tmp_tb t1 where not exists(select 1 from#tmp_tb t2 where t2.name=t1.name and t2.id)bianhao列为唯一标示列，显示大的小的都可以那直接查就可以了：select*from kucun t1 where not exists(select 1 from kucun t2 where t2.name=t1.name and t2.bianhao)
sql重复数据只显示一条 并且统计重复次数 你就没说明白select 字段，count(*)from 表名 group by 字段看看是这意思不？字段和表名自己替换下
SQL中如何让重复数据也显示出来 select*from t_goods where id in(1，2)union allselect*from t_goods where id in(2)或者select a2.*fromselect 1 as idunion allselect 2 as idunion allselect 2 as ida1left join t_goods a2 on a1.id=a2.id
