//第一种
SELECT *
FROM( SELECT A.*,
ROWNUM RN
FROM
(SELECT *
FROM CRM_TENDERS
ORDER BY TENDERSCODE DESC) A
WHERE ROWNUM <= 10 )
WHERE RN >= 5
//第二种
WITH OrderedOrders AS
(SELECT temp.*,
ROW_NUMBER() OVER (
ORDER BY TENDERSCODE DESC)AS RowNumber
FROM CRM_TENDERS temp)
SELECT *
FROM OrderedOrders
WHERE RowNumber BETWEEN 5 AND 10