odbtools/odbctest/mql/uino72/992.select.mql

/** 182 **/
;


SELECT temp.qx_name AS "区县名称", 
temp.raw_balance.time('2025-10-01 00:00:00','2025-10-07 23:59:59').find(name = 'cl') AS "余额存量明细" FROM 
(SELECT qx.name AS "qx_name", qx.balance AS "raw_balance" 
FROM /bc_post_demo/qx qx WHERE qx.name like '%云台%' LIMIT 0, 500000) temp LIMIT 0, 500000 WITH TIMEOUT = 6m
/**
output()
**/
;

SELECT qx.name AS "qx_name", qx.balance AS "raw_balance" 
FROM /bc_post_demo/qx qx WHERE qx.name like '%云台%' LIMIT 0, 500000
/**
output()
**/
;


SELECT qx.name AS "qx_name", qx.balance.time('2025-10-01 00:00:00','2025-10-07 23:59:59').find(name = 'cl') 
FROM /bc_post_demo/qx qx WHERE qx.name like '%云台%' LIMIT 0, 500000
/**
output()
**/
;