odbtools/odbctest/mql/uino/067countdistinct.mql

MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')
-[:person_to_tech_duty*1..1]->
(tech_duty:/univ_demo/tech_duty WHERE duty_level = '正高级' AND last_flag = '是') 
RETURN person.account AS "person_account", tech_duty.account AS "tech_duty_account" 
INTO /temp01_senior_teacher_701310d2-44f1-43cc-8fee-3f2cb9c37e06-0 WITH TIMEOUT = 6m
;


SELECT temp01.person_account
FROM /temp01_senior_teacher_701310d2-44f1-43cc-8fee-3f2cb9c37e06-0 temp01 LIMIT 0, 500000
/**
output()
**/
;

SELECT count(temp01.person_account) AS "senior_teacher_count" 
FROM /temp01_senior_teacher_701310d2-44f1-43cc-8fee-3f2cb9c37e06-0 temp01 LIMIT 0, 500000
/**
output()
**/
;

SELECT count(DISTINCT temp01.person_account) AS "senior_teacher_count" 
FROM /temp01_senior_teacher_701310d2-44f1-43cc-8fee-3f2cb9c37e06-0 temp01 LIMIT 0, 500000
/**
output()
**/
;


SELECT count(temp01.person_account) AS "senior_teacher_count" FROM (
    MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')
    -[:person_to_tech_duty*1..1]->
    (tech_duty:/univ_demo/tech_duty WHERE duty_level = '正高级' AND last_flag = '是') 
    RETURN person.account AS "person_account", tech_duty.account AS "tech_duty_account"
) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;

SELECT count(DISTINCT temp01.person_account) AS "senior_teacher_count" FROM (
    MATCH (person:/univ_demo/person WHERE status = '在职' AND person_sort = '事业编' AND staff_type = '专任教师岗位')
    -[:person_to_tech_duty*1..1]->
    (tech_duty:/univ_demo/tech_duty WHERE duty_level = '正高级' AND last_flag = '是') 
    RETURN person.account AS "person_account", tech_duty.account AS "tech_duty_account"
) temp01 LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;