SELECTCOUNT(*) FROM GPRXSJB WHERE GPDM ='000001' AND FSRQ < TO_DATE('2007-9-11','YYYY-MM-DD')
结果为 4054行
SQL1(ROWNUM方式):
SELECT* FROM ( SELECT SPJ FROM GPRXSJB WHERE GPDM ='000001' AND FSRQ < TO_DATE('2007-9-11','YYYY-MM-DD') ORDERBY FSRQ DESC ) WHERE ROWNUM =1;
执行平均时间为:7.8 s
SQL2(MAX方式):
SELECT* FROM GPRXSJB A, ( SELECTMAX(FSRQ) AS MAXDATE FROM GPRXSJB WHERE GPDM ='000001' AND FSRQ < TO_DATE('2007-9-11','YYYY-MM-DD') ) B WHERE A.GPDM ='000001' AND A.FSRQ = B.MAXDATE