odbtools/odbctest/mql/uino/062distinct.groupby.mql

select sz_g from /univ_demo/person WHERE sz_g != '' limit -1
/**
output()
count(1393)
**/
;


select sz_g from /univ_demo/person WHERE sz_g != '' group by sz_g
/**
output()
count(50)
**/
;

select distinct sz_g from /univ_demo/person WHERE sz_g != '' 
/**
output()
count(50)
**/
;

-- SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time" 
-- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%' 
-- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000
-- /**
-- output()
-- **/
-- ;

-- SELECT temp01.time AS "timestamp", 
-- temp01.business_trend.time('2026-02-17 00:00:00','').find(name = '总用户数') AS "total_users" 
-- FROM (SELECT area.business_trend_15m AS "business_trend", area.timestamp AS "time" 
-- FROM /zhejiang_mobile/area area WHERE area.event_name like '%2026春节网络保障%' 
-- AND area.area_name = '5ajiaxingnanhujingqu' LIMIT 0, 500000) temp01 LIMIT 0, 500000
-- /**
-- output()
-- **/
-- ;