不显示相同字段问题。两张表。

[ju897d]

两张表相连。显示某一字段不同的数据。select distinct ..........from where.. 不行。那样是根据整个记录，不同的显示出来相同的不显示。但是我要的是根据某一个字段，不同的部分显示出来相同的不显示。
比如：select id,pic from pic 可能一个id有好几个pic，我只要显示一个。比如第一个就行了。直接select distinct id，....不行。那样和没用distinct一样。

[dawugui]

select a.* from pic a,
(select id , min(pic) pic from pic group by id) b
where a.id = b.id and a.pic = b.pic

[bqb]

select id,max(pic)as pic from pic group by id

[dawugui]

select a.* from pic a where pic exists (select top 1 pic from pic where pic = a.pic)

[dobear_0922]

--try
select id, min(pic) from tb group by id

[dawugui]

如果只有ID,PIC两个字段.

select id , min(pic) from tb group by id
或
select id , max(pic) from tb group by id

如果要同时显示其他字段,用我上面给的代码.

[gahade]

楼主是不是想要这种结果?
drop table #t
go
create table #t(id char(1),pic varchar(10))
insert into #t
select '1','aa'
union all select '1','bb'
union all select '1','cc'
union all select '2','dd'
union all select '2','ee'
union all select '3','ff'

alter table #t add id1 int identity(1,1)

select case when id=(select id from #t b where a.id1=b.id1+1) then '' else a.id end as [id],a.pic
from #t a
/*
id pic
---- ----------
1 aa
bb
cc
2 dd
ee
3 ff

（所影响的行数为 6 行）
*/

[ju897d]

要是别的也显示也都用min一个人加过去？？那不汗死。

[dawugui]

别的也显示的话,不是加min.

要用

select a.* from pic a,
(select id , min(pic) pic from pic group by id) b
where a.id = b.id and a.pic = b.pic

或

select a.* from pic a where pic exists (select top 1 pic from pic where pic = a.pic)