SELECT A,B,C FROM TABLENAME WHERE C IN (SELECT C FROM TABLENAME GROUP BY C HAVING COUNT(*)=1)
select a,b,c from table1 where c in (select distinct c fromtable1) ------------------------------------ 体验速度,体验CSDN论坛助手:http://community.csdn.net/Expert/TopicView.asp?id=4700683
SELECT A,B,C FROM TABLENAME WHERE C IN (SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1)
上面錯了,改成這樣,呵呵: SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1
SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1
from table1
where c in
(select distinct c fromtable1)
------------------------------------
体验速度,体验CSDN论坛助手:http://community.csdn.net/Expert/TopicView.asp?id=4700683
SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1