ORA-00933:SQL命令未正确结束-(第2行出现错误)

Question

我不确定错误在哪里，

(第2行错误(

(帮助(

select last_name, first_name 
from employee group by Employee_ID in 
select Employee_ID from service group by Property_ID having count(*)>2;

---

员工表创建表EMPLOYEE(Employee_ID int主键，Last_name char(30(，名字字符(30(，手机字符(20(，ExperienceLevel字符(30(，CONSTRAINT EX_EMPLOYEE_EXPERINCEELEVEL CHECK(经验等级IN("硕士"、"初级"、"高级"(()；

服务表创建表SERVICE(Property_ID int，Employee_ID int，服务日期，Hours_worked int，主键(Property_ID、Employee_ID(，外键(Property_ID(引用Property(Property_IID(，外键(Employee_ID(引用Employee(Employme_ID()；

属性表创建表PROPERTY(Property_ID int主键，Owner_ID int，Owner_ Name字符(30(，所有者电子邮件字符(30(，Owner_ type char(30(，CONSTRAINT EX_PROPERTY_OWNERTYPE CHECK(所有者类型IN("个人"、"公司"、"合伙企业"(()；

Answer 1

您的查询不是很清楚。子查询之前的in子句在该位置不是有效子句。如果你想选择id在子查询中的员工，那么你必须这样做：

select last_name, first_name
from   employee
WHERE  Employee_ID in
(select Employee_ID from service
group by Property_ID having count(*)>2);