我用了distinct为什么还会有字段内容相同的记录出现

[满天飞舞rose]

我用了distinct为什么还会有字段内容相同的记录出现

[icedut]

你的字段内容确定相同么
是否有些别的字符

[满天飞舞rose]

我把他们转成ASC码也一样，你说我晕吗

[samuelpan]

是不是空格问题

加distinct ltrim(rtrim(column))

[伍子V5]

table
col1,col2,col3
111,111,111
111,111,222
111,222,222
如果你用distinct,是没法取col1的单条记录的
用group by 吧

[dlpseeyou]

用group by 试试

[满天飞舞rose]

请教group by的语法
"select distinct total,ename,wid,cname from words where cc='"&cc&"' and cname like '%"&ecname&"%' and dclassid in (select dclassid from dclass where dclassid ='"&dclassid&"' or fdclassid = '"&dclassid&"') order by total,cname "

[dlpseeyou]

select max(total),max(ename),max(wid),max(cname) from words groub by total where ....

[满天飞舞rose]

问题搞定谢谢了