odbtools/odbctest/mql/matrix/entity/100match.mql

-- match ('biz:*')-[*10]->(h) return h.name
/**
output()
**/
;


-- match (p:'biz:*')-[*10]->(h) return p.name as "业务", p.vtime as "业务时间", h.name as "合同", h.vtime as "签约时间" into temp0001
-- ;


-- match (p:'biz:*')-[*10]->(h) return p.name as "业务", _.path as "路径", h.name as "合同"
/**
output()
**/
;


match (p:'biz:*')-[*10]->(h) return p.name as "业务", _.path as "路径", h.name as "合同" into temp0001
;

select * from temp0001
/**
output()
**/
;


select 业务, count(t.合同) from temp0001 t group by 业务 order by 业务 desc
/**
output()
**/
;