Lateral

分类

/ 注册

全部文章（共102篇）

题解 | 查询培训指定课程的员工信息

select c.staff_id, s.staff_name from cultivate_tb c left join staff_tb s on c.staff_id=s.staff_id where c.course like '%course3%'

2025-03-03

16 36

题解 | 统计所有课程参加培训人次

select sum(t1.c1_nums)+ sum(t1.c2_nums)+ sum(t1.c3_nums) as staff_nums from (select staff_id, case when instr(c.course,'1')!=0 then 1 else 0 end a...

2025-03-03

0 48