删除表中两列相同的内容

[tsmfkd]

如下表
date no zy jf df
2008.01.01 1 税 12,358.00
2008.01.02 2 税 32,943,876.00
2008.01.03 3 税 43.00
2008.01.04 4 税 46,598.00
2008.01.05 5 税 590.00
2008.01.06 6 税 224.00
2008.01.07 7 税 442.00
2008.01.08 8 税 12,358.00
2008.01.09 9 税 32,943,876.00
2008.01.10 10 税 23.00
2008.01.11 11 税 43.00
2008.01.12 12 税 46,598.00
2008.01.13 13 税 590.00
2008.01.14 14 税 224.00
2008.01.15 15 税 442.00
2008.01.16 16 税 3,341.00
2008.01.17 17 税 4,524.00
2008.01.18 18 税 4,344.00
2008.01.19 19 税 4,555.00
2008.01.20 20 税 3,334.00
2008.01.21 21 税 768.00
2008.01.22 22 税 3,445.00
2008.01.23 23 税 3,141.00
想删除该表中两列内容相同的行,或用查询只看到该表中两列内容不相同的行

[feixianxxx]

select distinct * 
from tb 

[feixianxxx]

忽然发现你的数据好像都不相同

[--小F--]

select 
   * 
from 
  tb 
where 
  jf 
in
  (select jf from tb where group by jf having count(1)=1)

[SQL77]

SELECT * FROM TB T WHERE NOT EXISTS(SELECT 1 FROM TB WHERE JF=T.JF AND DATE<>T.DATE)

[lihan6415151528]

SELECT * FROM TB T
 WHERE NOT EXISTS
(SELECT 1 FROM TB WHERE JF=T.JF AND DATE<>T.DATE)

[tnthanxu]

select distinct * from 表名
后者采用分组
select date,no,zy,jf,df from 表名 group by date,no,zy,jf,df

[linguojin11]

select distinct *
from tb

[唯咖啡与茶]

定义游标，因为SQL是一次一集合的操作，删除重复记录会一次性删除所有相同的记录，一条也不剩下。我曾经用过的一个游标，解决楼主类似问题的问题
use DBNM
go
declare @max integer,@id varchar(128)
declare cur_rows cursor local for select Columnnm ,count(Columnnm )
from tablenm
group by Columnnm
having count(Columnnm ) > 1
open cur_rows
fetch cur_rows into @id,@max
while @@fetch_status=0
begin
select @max = @max -1
set rowcount @max
delete from tablenm
where Columnnm = @id
fetch cur_rows into @id,@max
end
close cur_rows
set rowcount 0

[fwacky]

select distinct * from tb

[yijianboy]

mark