Oracle 查询结果集中的一行或多行

查询结果集的一行：

SELECT * FROM (SELECT T2.FMZT,MAX(T2.TR_DATE || T2.TR_TIME) AS TIME
FROM M_DOOR_POS T1,B_DOORCONTROL_200001 T2
WHERE T1.ZDBH=T2.ZDBH AND T1.ENTERPRISE='200001' AND T1.DOOR_ID='3'
GROUP BY T2.FMZT ORDER BY TIME DESC) WHERE rownum=1;

 

查询结果集的多行：

SELECT * FROM (SELECT T2.FMZT,MAX(T2.TR_DATE || T2.TR_TIME) AS TIME
FROM M_DOOR_POS T1,B_DOORCONTROL_200001 T2
WHERE T1.ZDBH=T2.ZDBH AND T1.ENTERPRISE='200001' AND T1.DOOR_ID='3'
GROUP BY T2.FMZT ORDER BY TIME DESC) WHERE rownum between 1 and 60