oracle分页+排序查询的结果不符合预期

问题描述

在oracle数据库中，使用分页查询并对某个字段进行了排序，查询出来的结果中stock_quantity字段的值跟预期的不一样

具体疑问

这是什么原因造成的，要怎么解决

sql

▼
sql
复制代码
SELECT
            ROWNUM ROW_ID,
    TMP_PAGE.*
FROM ( select g.id as goods_id, g.name, g.category, g.details, g.recommendation_flag, g.inaccurate_stock_quantity,
              g.inaccurate_exchange_quantity, g.stock_quantity, g.exchange_quantity, g.createtime,
              gcr.id as goods_change_record_id, gcr.listing_time, gcr.de_listing_time, gcr.valid_flag,
              gcr.exchange_method, gcr.integral1, gcr.integral2, gcr.amount, gp.id as goods_photo_id, gp.url
       from goods g right join goods_change_record gcr on g.id = gcr.goods_id
           left join goods_photo gp on g.id = gp.goods_id
       where 1 = 1 order by goods_id desc) TMP_PAGE WHERE ROWNUM <= 10

sql运行截图

单独运行子查询 运行整个查询