mysql 查询重复的记录
摘要：SELECT * FROM workorder_role_skill WHERE (roleCode, skillCode) IN ( SELECT roleCode,skillCode FROM workorder_role_skill GROUP BY roleCode,skillCode HA
阅读全文
posted @
2022-05-17 14:14
爷的眼睛闪亮
阅读(44)
推荐(0) 编辑
mysql union all 连表查询如何知道结果来自哪张表?
摘要：select w.woType, 'NO_HIS' as dataFromfrom workorder_complet_info wwhere w.workOrderNo = 'xxxxxx'union all select w.woType, 'HIS' as dataFromfrom worko
阅读全文
posted @
2022-05-12 12:33
爷的眼睛闪亮
阅读(204)
推荐(0) 编辑
