--根据receipt_date 进行 降序编号 然后取 500-600SELECT * FROM( SELECT ROW_NUMBER() OVER(ORDER by receipt_date)rn,* FROM pureceipt)p where p.rn BETWEEN 500 AND 600
