DB2:FETCH FIRST 1 ROWS ONLY
时间：2021-07-01 10:21:17
帮助过：70人阅读
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
例如：
DB2:FETCH FIRST 1 ROWS ONLY
标签：div desc http logs 分享 row .com blog image
