3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
满天飞舞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
你的字段内容确定相同么
是否有些别的字符
是否有些别的字符