摘要:
第一种方法: SELECT d.label AS name,d.value, (SELECT count(1) FROM project.s_major_project p WHERE p.type = d.value) AS count FROM westlake.z_dict d where t 阅读全文
摘要:
SUBSTRING (字符串,起始位置(从1开始) , 子串长度) --取子串RIGHT(字符串, N) --取右边的N个字符LEFT(字符串, N) --取左边的N个字符 阅读全文
![](/skins/gray/images/separator.gif)