题解 | 查询培训指定课程的员工信息
with temp as(
select
case when course like '%course3%' then 1 else 0 end as course_3,
a.staff_id,
staff_name
from staff_tb a inner join cultivate_tb b
on a.staff_id=b.staff_id
)
select
staff_id,
staff_name
from temp where course_3=1
查看13道真题和解析
