odbtools/odbctest/mql/uino/060.mql

SELECT 	 id,cast(vtime as bigint) as ntime,  cast(vtime as timestamp) as stime FROM 	 /matrix/filesystem
/**
output()
**/
;

SELECT 	 id,cast(vtime as bigint) as ntime,  cast(vtime as timestamp) as stime FROM 	 /matrix/filesystem where vtime='1741613787088'
/**
output()
**/
;


SELECT 	 id,cast(vtime as bigint) as ntime, cast(vtime as timestamp) as stime FROM 	 /matrix/filesystem where vtime='2025-03-10 21:36:27.088'
/**
output()
**/
;


select count(id) as count_id, count(distinct day) as count_day from /univ_demo/org
/**
output()
**/
;


select * from /univ_demo/org
/**
output()
**/
;

select * from /univ_demo/person
/**
output()
**/
;

match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) return org.id as org_id, person.id as person_id
/**
output()
**/
;


match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) 
return person.id as "person_id", org.id as "org_id"
/**
output()
**/
;


select count(distinct org_id),org_id from 
(match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) return org.id as org_id, person.id as person_id)
group by org_id having count(distinct person_id)>20
/**
output()
**/
;


select count(aaa.org_id) as lll,aaa.org_id from 
(match (person:/univ_demo/person)-[:person_to_org]->(org:/univ_demo/org) return person.id as "person_id", org.id as "org_id") aaa
group by aaa.org_id having count(distinct aaa.person_id)>=20
/**
output()
**/
;