一、问题描述
使用Oracle的分页语句进行分页,第一页,没问题,第二页出现重复数据:
第一页的数据:
SELECT *
FROM (
SELECT u.*, rownum AS r
FROM (
SELECT configs.VIDEOSERVICE, configs.VOICESERVICE, configs.IMAGESERVICE, doc.id AS docid, doc.name AS docname
, doc.begood, rice.graphicprice, rice.speechprice, rice.videoprice, chart.titleName
, hpath.FTPURL || doc.PHOTOID AS ftpurl, luate.score
FROM HEALTHDOCTOR doc
LEFT JOIN HealthServiceConfig configs ON doc.id = configs.docid
LEFT JOIN HEALTHPRICE rice ON doc.id = rice.docid
LEFT JOIN healthTitleChart chart ON doc.titlecode = chart.TITLECODE
LEFT JOIN HEALTHFTPPATH hpath ON doc.PATHCODE = hpath.PATHCODE
LEFT JOIN (
SELECT round(AVG(score), 1) AS score, docid
FROM healthevaluate
GROUP BY docid
) luate ON doc.id = luate.docid
LEFT JOIN (
SELECT C