SELECT * FROM SMS_OUT_BOX T WHERE T.SEND_TIME < CURRENT TIMESTAMP AND T.STATUS=0 AND (T.IS_DEAL=0 OR T.IS_DEAL=7) ORDER BY T.SEND_TIME ASC FETCH FIRST "+count+" ROWS ONLY
DB2查询前n条记录的数据
最新推荐文章于 2021-12-22 17:01:14 发布
SELECT * FROM SMS_OUT_BOX T WHERE T.SEND_TIME < CURRENT TIMESTAMP AND T.STATUS=0 AND (T.IS_DEAL=0 OR T.IS_DEAL=7) ORDER BY T.SEND_TIME ASC FETCH FIRST "+count+" ROWS ONLY