SQL简单问题，在线给分。

[hzyzx]

我有一表TABLE1中 N列字段数据，我的主键是三个字段NUM，IDNO，NAME
现在列NUM的数据肯定有重复，问题是我现在需要把NUM列重复的数据出掉
又要列出所有字段，该怎么办？

[N_chow]

不知道是否是這樣?

SELECT NUM,MIN(IDNO) AS IDNO,MIN(NAME) as Name,MIN(...) as ...,MIN(...) as .......
From tableName
GROUP BY NUM

[Yang_]

select * from tablename a
where idno=
(
select min(idno) as idno from tablename where num=a.num
)
and NAME=(
select min(NAME) as NAME from tablename where num=a.num and idno=a.idno
)

[x_zing]

--1,拿到你要的数据
select num,max(idno),max(name),...into table2 from table1
group by num
--2,在table2上加上主键(略）
--3,删除table1
drop table table1
--4,改table2为table1
sp_rename 'table2','table1'

[wylyf]

select * from #tmp where num in(
select num from #tmp group by num having count(num)>1)
可以把所有NUM重复的列显示出来

想删除的话：
delete from #tmp where num in(
select num from #tmp group by num having count(num)>1)