一开始默认为以 ORDERNO 这个字段名为升序 然后再以上面那个参数排序 怎末设置
order by ${if(len(a)==0,""," actual_delivery*1 "+a+",")} orderno asc
动态排序32.rar
参考文件
------------------
select * from b
${if(len(a)=0,"order by ORDERNO asc","order by zd * a '"+a+"'")}
1min目标场景问卷
立即参与
