阿善 · 2006-09-18 08:30:03 · 阅读: 535 记录一下 SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM platfomr_device_state ORDER BY collect_time DESC) DERIVEDTBL ORDER BY collect_time) DERIVEDTBL ORDER BY collect_time DESC