selec distinct decl_no,* from (select distinct hs_code,* from(select distinct goods_cname,* from(select distinct fee_item_codes,* from (select distinct goods_no,* from temp))))
selec distinct decl_no,* from (select distinct hs_code,* from(select distinct goods_cname,* from(select distinct fee_item_codes,* from (select distinct goods_no,* from temp))))
fee_item_codes<>goods_no
max(Hs_Code) Hs_Code ,
max(Goods_Cname),Goods_Cname
max(Fee_Item_Codes),Fee_Item_Codes
max(Goods_No) Goods_No
from temp
group by hs_code,fee_item_codes,goods_no
max(Hs_Code) Hs_Code ,
max(Goods_Cname),Goods_Cname
max(Fee_Item_Codes),Fee_Item_Codes
max(Goods_No) Goods_No
from temp
group by hs_code,fee_item_codes,goods_no
SELECT A.* FROM TEMP ,(select Hs_Code Hs_Code ,
Fee_Item_Codes Fee_Item_Codes,
Goods_No Goods_No
from temp
group by hs_code,fee_item_codes,goods_no
having count(*)=1) B
WHERE A.hs_code=B.hs_code
AND A.fee_item_codes=B.fee_item_codes
AND A.goods_no=B.goods_no
SELECT A.* FROM TEMP ,(select Hs_Code Hs_Code1 ,
Fee_Item_Codes Fee_Item_Codes1,
Goods_No Goods_No1
from temp
group by hs_code,fee_item_codes,goods_no
having count(*)=1) B
WHERE A.hs_code=B.hs_code1
AND A.fee_item_codes=B.fee_item_codes1
AND A.goods_no=B.goods_no1
from Temp
where
hs_code in (select hs_code from temp group by hs_code having count(hs_code) = 1) and
fee_item_codes in (select fee_item_codes from temp group by fee_item_codes having count(fee_item_codes) = 1) and
goods_no in (select goods_no from temp group by goods_no having count(goods_no) = 1)
WHERE
hs_code IN (SELECT hs_code FROM temp
GROUP BY hs_code HAVING Count(hs_code) = 1) --/判断hs_code是否重复
AND
fee_item_codes IN (SELECT fee_item_codes FROM temp
GROUP BY fee_item_codes HAVING Count(fee_item_codes) = 1) --/判断fee_item_codes是否重复
AND
goods_no IN (SELECT goods_no FROM temp
GROUP BY goods_no HAVING Count(goods_no) = 1) --/判断goods_no是否重复
可以理解为三个字段分别不重复,那就是我上面给出的查询结果
如果理解为三个字段组合不重复,那就要简单一点了,只要三个字段组合起来判断是否重复select Decl_No,Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No
from Temp
where
hs_code + fee_item_codes + goods_no in
(select distinct hs_code + fee_item_codes + goods_no as id from temp)
您写的出错了.
我的数据库是access2000....--------------
谢谢了.
from Temp
where
hs_code + fee_item_codes + goods_no in
(select distinct hs_code + fee_item_codes + goods_no as id from temp)
记得不要将“自动编号”设置为主键,把你要“不重复”的列设置为索引,就可以了。还不明白?不需要“不重复”的列按正常处理就行了。
Decl_No Hs_Code Goods_Cname Fee_Item_Codes Goods_No
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 010102 1
210100101017534 21031000 酱油 030403 1
210100101017534 21031000 酱油 030403 1
210100101017534 21031000 酱油 030403 1
210100101017534 21031000 酱油 030403 1
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21031000 酱油 030403 2
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 21039090 大酱 030403 3
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 4
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 22090000 醋 030403 5
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 沙司 030403 6
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
210100101017534 21039090 料酒 030403 7
可以这样写:
SELECT SUM(Decl_No),Hs_Code,SUM(Goods_Cname),Fee_Item_Codes,Goods_No FROM TEMP
GROUP BY hs_code,fee_item_codes,goods_no
Decl_No Hs_Code Goods_Cname Fee_Item_Codes Goods_No
210100101017534 21039090 料酒 030403 7
可以这样写:
SELECT SUM(Decl_No),Hs_Code,SUM(Goods_Cname),Fee_Item_Codes,Goods_No FROM TEMP
GROUP BY hs_code,fee_item_codes,goods_no
SELECT Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No FROM TEMP
GROUP BY Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No
Decl_No都是一样的那就不用选了,这样应该是有结果的!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
正确!!!!!!!!!!!!!!!!!!!!!!!!!!!正确!!!!!!!!!!!!!!!!!!!!!!!!!!!
-----------------------
谢谢大家...参与有分...
结账....
比如:Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No,fee_item_desc,calcu_fee_mode,fee,fee_std_rate,temp_disc,std_weight,value_rmb,std_qty,decl_no
选择在这里面的 Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No 都不重复的记录...
-----------
我怎么都选不出???
另外.我怎么也给不了分....
csdn怎么这样????
从 Temp 表中选出所有的数据(字段名如下) Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No,fee_item_desc,calcu_fee_mode,fee,fee_std_rate,temp_disc,std_weight,value_rmb,std_qty,decl_no
条件是
Hs_Code,Goods_Cname,Fee_Item_Codes,Goods_No 都不重复的记录...
刚才哈林都作了.但是那个只是一部分的数据.现在要求选择出所有的字段值.
表就是上面我列出的那样的数据...
谢谢了...