摘要: 1、sql排序 #字符串替换SELECT replace('C123~','~','') as int from dual;CAST ("REPLACE"(REPLACE (sp.plantNumber, '~', ''), 'C', '') AS INT) ASC #排序 #是否包含某个字符SEL 阅读全文
posted @ 2022-05-06 14:23 小吴dnd 阅读(17) 评论(0) 推荐(0) 编辑