34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
满天飞舞rose 2003-12-15
- 打赏
- 举报
问题搞定谢谢了
dlpseeyou 2003-12-15
- 打赏
- 举报
select max(total),max(ename),max(wid),max(cname) from words groub by total where ....
满天飞舞rose 2003-12-15
- 打赏
- 举报
请教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 "
"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 2003-12-15
- 打赏
- 举报
用group by 试试
伍子V5 2003-12-15
- 打赏
- 举报
table
col1,col2,col3
111,111,111
111,111,222
111,222,222
如果你用distinct,是没法取col1的单条记录的
用group by 吧
col1,col2,col3
111,111,111
111,111,222
111,222,222
如果你用distinct,是没法取col1的单条记录的
用group by 吧
samuelpan 2003-12-15
- 打赏
- 举报
是不是空格问题
加distinct ltrim(rtrim(column))
加distinct ltrim(rtrim(column))
满天飞舞rose 2003-12-15
- 打赏
- 举报
我把他们转成ASC码也一样，你说我晕吗
icedut 2003-12-15
- 打赏
- 举报
你的字段内容确定相同么
是否有些别的字符
是否有些别的字符
