例如：
DB2:FETCH FIRST 1 ROWS ONLY
标签：div desc http logs 分享 row .com blog image
DB2:FETCH FIRST 1 ROWS ONLY
ROWS ONLY，在Oracle中使用where rownum=1代替
DB2：
SELECT INSTORAGENO FROM
(
SELECT max(AUDITINGTIME) AUDITINGTIME ,INSTORAGENO FROM T_IN_STOREROOM
order by AUDITINGTIME desc
FETCH FIRST 1 ROWS ONLY
) a
Oracle：
SELECT INSTORAGENO FROM
(
SELECT max(AUDITINGTIME) AUDITINGTIME ,INSTORAGENO FROM T_IN_STOREROOM
order by AUDITINGTIME desc
) a where rownum=1