错误写法:
SELECT * FROM(
SELECT progressid FROM ANALYSERESULT WHERE instrumentid = 'GC-DID-39-XE-101' group by progressid ORDER BY max(createtime) DESC) WHERE ROWNUM = 2
正确写法:
select progressid from (SELECT progressid,rownum rn FROM(
SELECT progressid FROM ANALYSERESULT WHERE instrumentid = 'GC-DID-39-XE-101' group by progressid ORDER BY max(createtime) DESC)) WHERE rn = 2