1.日期类型查询
CREATED_DATE >= to_date('20190109','yyyy-MM-dd')
2.不等于
ORDER_STATUS <> ?
3.分页sql
SELECT
*
FROM
( SELECT
TMP.*,
ROWNUM ROW_ID
FROM
( SELECT
PRODUCT_CONFIG_ID AS productConfigId,
channel_id AS channelId
FROM
T_PRODUCT_CONF
WHERE
(
CHANNEL_ID ='2222'
)
ORDER BY
CREATED_DATE DESC ) TMP
WHERE
ROWNUM <=12
)
WHERE
ROW_ID > 0
ROW_ID > 0(开始行数为0),ROWNUM <=12(行数小于等12条)
参考链接:https://www.cnblogs.com/ladyM/p/8378548.html