301.return包含where-orderby-limit.mql 512 B

123456789101112131415
  1. MATCH (staff:/mingdao1/staff WHERE attr1 = '钟宏')-[:is_solve_person_of_case]->(case:/mingdao1/case WHERE attr30 >= '2024-01-01' AND attr30 <= '2024-12-31')-[:is_case_of_project]->(project:/mingdao1/project)<-[:is_contract_of_project]-(contract:/mingdao1/contract), (project)<-[:is_admin_of_project]-(pm:/mingdao1/staff)
  2. RETURN contract.attr18 AS "contract_amount", pm.attr1 AS "pm_name", pm.attr0 AS "pm_id"
  3. WHERE contract_amount is not null
  4. ORDER BY contract_amount desc
  5. LIMIT 5
  6. /**
  7. output()
  8. **/
  9. ;