odbtools/odbctest/mql/uino/403.orderby全面测试.mql

MATCH (budget:/birddata/budget)-[:budget_link_to_event_event_event_id*1..1]->(event:/birddata/event WHERE event_name = 'April Speaker') 
RETURN budget.category AS "category", budget.amount AS "amount" INTO /t0_189295;

SELECT t0.amount AS "t0.category", t0.category AS "Budget Category", t0.amount AS "Amount Budgeted" FROM /t0_189295 t0 ORDER BY t0."amount" ASC LIMIT 0, 20000
 
/**
output()
metainfo()
**/
;


SELECT t0.amount AS "t0.category", t0.category AS "Budget Category", t0.amount AS "Amount Budgeted" FROM /t0_189295 t0 ORDER BY "Amount Budgeted" ASC LIMIT 0, 20000
 
/**
output()
metainfo()
**/
;


 SELECT room.using_department AS "using_department" INTO /t0 FROM /hxyy/room room LIMIT 0, 20000
  
/**
output()
metainfo()
**/
;

 SELECT t0.using_department AS "使用部门" FROM /t0 where t0.using_department is null
 /**
output()
**/
;
 
 SELECT t0.using_department AS "使用部门", count(t0.using_department) AS "房间数量", count(*) AS "房间数量x" FROM /t0 t0 GROUP BY t0."using_department" ORDER BY "房间数量" DeSC LIMIT 0, 20000
 
/**
output()
metainfo()
**/
;