摘要:
select sum(duration_time) as quantity,account,user_name,dept_name,parent_dept from blade_employee_training_record_detail where tenant_id=#{tenantId} < 阅读全文
摘要:
MySQL根据多个字段删除重复数据(保留一条) 在成千上万条数据中,存在着一些相同的记录,该如何用SQL语句来删除掉重复的呢 话不多说直接上代码 DELETE FROM 表名 WHERE S_ID IN ( SELECT S_ID FROM 表名 A, ( SELECT 字段 1, 字段 2 FRO 阅读全文
摘要:
select sum(a.duration_time) as quantity,b.dept_name,b.user_quantity from blade_employee_training_record_dept_user_quantity b LEFT JOIN (select * from 阅读全文