多选题

知识点：数据库 6/10（单选/必答） Which of the fo...

Question

知识点：数据库 6/10（单选/必答）

Which of the following queries return the employee names who has attended any training more than once?

A. select e.name from employees e join trainings t on e.eid=t.eid group by e.name having (count(*)&lt&gtcount(distinct coursename))

B. select e.name from employees e join trainings t on e.eid=t.eid group by e.name having (count(distinct coursename)&gt1)

C. select e.name from employees e join trainings t on e.eid=t.eid group by e.name having (count(coursename)&gt1)

D. None of the options are correct .