MATCH (staff:/mingdao1/staff WHERE attr0 = 'UN0067') -[:is_duty_sales_of_contract|is_member_sales_of_contract|is_pm_of_contract|is_presales_of_contract|is_sales_of_contract*1..1]-> (contract:/mingdao1/contract) -[:is_contract_of_project*1..1]-> (project:/mingdao1/project) RETURN contract.attr2 AS "contract_id", contract.attr1 AS "contract_name", project.attr0 AS "project_id", project.attr3 AS "project_name", project.attr66 AS "total_amount" /** output() **/ ; MATCH (staff:/mingdao1/staff WHERE attr0 = 'UN0067') -[:is_duty_sales_of_contract|is_member_sales_of_contract|is_pm_of_contract|is_presales_of_contract|is_sales_of_contract*1..1]-> (contract:/mingdao1/contract) -[:is_contract_of_project*1..1]-> (project:/mingdao1/project) RETURN contract.attr2 AS "contract_id", contract.attr1 AS "contract_name", project.attr0 AS "project_id", project.attr3 AS "project_name", project.attr66 AS "total_amount" INTO aaaaaa; ; SELECT temp.contract_id AS "合同编号", temp.contract_name AS "合同名称", temp.project_id AS "项目ID", temp.project_name AS "项目名称", temp.total_amount AS "项目总金额(元)" FROM aaaaaa temp LIMIT 0, 10 /** output() **/ ; SELECT temp.contract_id AS "合同编号", temp.contract_name AS "合同名称", temp.project_id AS "项目ID", temp.project_name AS "项目名称", temp.total_amount AS "项目总金额(元)" FROM aaaaaa temp ORDER BY total_amount DESC LIMIT 0, 10 ;