SELECT *
FROM (
SELECT TMP., ROWNUM AS ROW_ID
FROM (
SELECT *
FROM (
SELECT base., ROW_NUMBER() OVER (PARTITION BY base.BIZID ORDER BY base.ORDER_NUM DESC, base.ID DESC) AS RN
FROM BASE_SYS_FAQ base
LEFT JOIN BASE_SYS_FAQ_ORG org ON base.bizid = org.FAQ_ID
AND org.MOF_DIV_ID = ‘1c0a58de5a704cce8c6ee8bf06844278‘
WHERE base.PUB_DATE >= to_date(to_char(‘2021-07-16 00:00:00.0‘, ‘yyyy-mm-dd‘) || ‘ 00:00:00‘, ‘yyyy-mm-dd hh24:mi:ss‘)
AND base.PUB_DATE <= to_date(to_char(‘2021-07-17 00:00:00.0‘, ‘yyyy-mm-dd‘) || ‘ 23:59:59‘, ‘yyyy-mm-dd hh24:mi:ss‘)
AND base.IS_DELETED = 0
AND base.MOF_DIV_ID = ‘1c0a58de5a704cce8c6ee8bf06844278‘
ORDER BY base.ORDER_NUM DESC, base.ID DESC
)
WHERE RN = 1
) TMP
WHERE ROWNUM <= 20
)
WHERE ROW_ID > 0
相关文章
- 01-03SQL 表连接查询出现重复列,由此理清LEFT JOIN、INNER JOIN的区别
- 01-03在有大量数据时 少用In(数据会丢失) 用left join 代替
- 01-03数据库中的LEFT JOIN 个人理解
- 01-03数据库多表查询时小小的区别:inner join 与left join
- 01-03数据库表的连接(Left join , Right Join, Inner Join)
- 01-03left join 的一些问题,不一定以左表为准,数据行数减少或者数据增多,打破你的认知
- 01-03数据库表的连接(Left join , Right Join, Inner Join)用法详解
- 01-03left join产生重复数据
- 01-03hsql数据量大的时候 left join 查询非常慢
- 01-03oralce sql优化-包含多表not exists转left join,一个表查询重复数据