odbtools/odbctest/mql/uino/502.unit函数测试.mql

-- SELECT * FROM /mingdao1/staff LIMIT 1
-- /**
-- output()
-- **/
-- ;

-- SELECT id, staff_perf.time('2023-06-01 00:00:00','').find(name = 'CN002859P') FROM /mingdao1/staff staff 
-- /**
-- output()
-- **/
-- ;

-- SELECT id, staff_perf.time('2023-06-01 00:00:00','').find(name = 'CN002859P').unit('avg', '1d') FROM /mingdao1/staff staff LIMIT 0, 10
-- /**
-- output()
-- **/
-- ;

SELECT id, staff_perf.time('2000-01-01 00:00:00','').find(name = 'CN002859P').unit('sum', 'month') FROM /mingdao1/staff staff
/**
output()
**/
;

SELECT id, staff_perf.time('2023-06-01 00:00:00','2023-07-01 00:00:00').find(name = 'CN002859P').unit('sum', 'month'), staff.attr1 AS "员工姓名", staff.attr0 AS "员工工号" FROM /mingdao1/staff staff WHERE staff_perf.time('2023-06-01 00:00:00','').find(name = 'CN002859P').unit('sum', 'month').assert($1 > 40) LIMIT 0, 100
/**
output()
**/
;