古寒居

现在有三张表Agents 里面的字段有cid workId password typeAGRelation 里面有workId Gid EtGroup 里面有Gid GroupName select Agents.workId,Agents.name,Agents.type,EtGroup.groupName from (Agents inner join AGRela...

SQL2000 的三个驱动

Isnull、like、top、order by desc、convert、substring、as工作中的例子1.select top 1 convert(float,isnull(gryjce,0.001))*2 as gryjce from vet_gryjce_zgzt where kh=convert(int,'%v') order by gryjce desc...

同一个功能但是在两个数据库中的不同用法这个是sql中的语句select top 5 cid,workid from agents这个是mysql中的语句SELECT * FROM lnaccumulation.callslog limit 5...