odbtools/odbctest/mql/uino/601.count distinct.mql

SELECT * from /hxyy/floor
/**
output()
**/	
;

SELECT floor1.affiliated_building AS "affiliated_building" INTO /t11021 FROM /hxyy/floor floor1 WHERE floor_number > '5' LIMIT 0, 200
;

{
	"sql":"SELECT * from /t11021"
}
/**
output()
**/	
;

{
	"sql":"SELECT count(DISTINCT t11021.affiliated_building) AS \"五楼以上的建筑个数\" FROM /t11021 t11021 LIMIT 0, 20000"
}
/**
output()
**/
;

{
	"sql":"SELECT count(DISTINCT t11021.affiliated_building) AS \"五楼以上的建筑个数\" FROM T_t11021 t11021 LIMIT 0, 20000",
	"class":["/t11021"]
}
/**
output()
**/
;