我的表里有a,b,c三个字段,现在要查出c不重复的记录,但要包括a和b:

[huangheng1983]

我的表里有a,b,c三个字段,现在要查出c不重复的记录,但要包括a和b:
select a,b,DISTINCT c from ...
但却报告有错,那怎么达到我的目的?

[aiirii]

group by a,b
group

• 打赏
• 举报

回复 赞

[yqacml]

up

• 打赏
• 举报

回复 赞

[duxbin]

SELECT A,B,C FROM TABLENAME WHERE C IN (SELECT C FROM TABLENAME GROUP BY C HAVING COUNT(*)=1)

• 打赏
• 举报

回复 赞

[gerryxu]

up

• 打赏
• 举报

回复 赞

[wudi_1982]

SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1

• 打赏
• 举报

回复 赞

[Rubi]

select a,b,c
from table1
where c in
(select distinct c fromtable1)
------------------------------------
体验速度,体验CSDN论坛助手:http://community.csdn.net/Expert/TopicView.asp?id=4700683

• 打赏
• 举报

回复 赞

[dgsunrise]

SELECT A,B,C FROM TABLENAME WHERE C IN (SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1)

• 打赏
• 举报

回复 赞

[dgsunrise]

上面錯了，改成這樣，呵呵：
SELECT A,B,C FROM TABLENAME GROUP BY A,B,C HAVING COUNT(*)=1

• 打赏
• 举报

回复 赞