odbtools/odbctest/mql/uino/090.orderbylimit.mql

SELECT room.usable_area AS "usable_area"  FROM /hxyy/room room ORDER BY "usable_area" ASC LIMIT 1000
/**
output()
timeout(60m)
**/
;


SELECT room.usable_area AS "usable_area" into temproom FROM /hxyy/room room
/**
output()
timeout(60m)
**/
;

SELECT room.usable_area AS "usable_area"  FROM temproom room ORDER BY "usable_area" LIMIT 0, 1000
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM temproom room ORDER BY "usable_area" LIMIT 0, 3
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM temproom room where usable_area is not null ORDER BY "usable_area" asc LIMIT 0, 3
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM temproom room ORDER BY "usable_area" desc LIMIT 0, 3
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM /hxyy/room room ORDER BY "usable_area" ASC LIMIT 0, 3 
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM /hxyy/room room WHERE usable_area is not null ORDER BY "usable_area" ASC LIMIT 0, 3 
/**
output()
**/
;

SELECT room.usable_area AS "usable_area"  FROM /hxyy/room room ORDER BY "usable_area" DESC LIMIT 0, 3
/**
output()
**/
;