ID_, PCODE_, PNAME_, SUBJECT_CODE_, SUBJECT_NAME_, COMPANY_ID_, COMPANY_NAME_, CREATE_BY_, CREATE_NAME_, CREATE_ORG_NAME_, CREATE_COMPANY_ID_, CREATE_COMPANY_NAME_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_BY_, UPDATE_NAME_, UPDATE_COMPANY_NAME_, UPDATE_COMPANY_ID_, UPDATE_ORG_ID_, UPDATE_ORG_NAME_, UPDATE_TIME_, LAST_TIME_, IS_DELE_, VERSION_,SN_,HAS_CHILDREN select ID_ ,PCODE_,PNAME_, ( case (select count(*) from biz_course_details p where p.PCODE_=o.ID_ and p.ID_!=p.PCODE_ AND p.IS_DELE_!='1') when 0 then 0 else 1 end )isIsParent from biz_course_details o where PCODE_=#{pCode} AND IS_DELE_!='0' SELECT * FROM biz_course_details ${ew.customSqlSegment} select count(PCODE_) from biz_course_details WHERE PCODE_ = #{pCode};