github_38237196的博客

#更新顺序 SET @num=0; UPDATE casedetail SETstatus = (@num:= @num+1) WHERE caseId = 104

wm_concat() 这个函数可以把结果合并成一行用逗号隔开 select wmsys.wm_concat(SF) as TOP3 from ( select SF, sum(ZZTS) as ZTS from DM_YYZZSJTJ_YPZZB group by SF order by ZTS ) where rownum<=3 参考链接：https://www.cnbl...