菜鸟求知：唯一行

[wxshzf]

我有一表内容如下：
billNo extension billdate billtime duration
1 83561000 2003-05-01 14:07:05 34
2 83561000 2003-05-01 14:07:05 34
3 83561008 2003-05-02 11:07:05 341
4 83561008 2003-05-02 11:07:05 341
5 83561045 2003-05-07 14:10:05 334
6 83561045 2003-05-07 14:10:05 334
7 83561093 2003-05-09 14:07:52 134
8 83561093 2003-05-09 14:07:52 134

9 83561188 2003-04-09 14:03:5 112
10 83561188 2003-05-03 14:07:52 134

..........................
有10000行，有许多相邻的2行相同，只需保留一行，不雷同的行仍保留在表中，请高手们指教！

[愉快的登山者]

select distinct * into #t from yourtable
go
delete yourtable
go
insert yourtable select * from #t
go
drop table #t
go

[愉快的登山者]

delete from yourtable as A
where billNo <> (select min(billNo) from yourtable
where extension = A.extension
and billdate = A.billdate
and billtime = A.billtime
and duration = A.duration)

[饮水需思源]

select distinct * from tablename

[yoki]

选出非重复行
这样即可：
select distinct * from tablename

[dlkfth]

select distinct * from tablename