oracle关联表会重复,Oracle多表联查分页数据重复出现

一、问题描述

使用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