SELECT * FROM (SELECT rdate, SUM (count_value), a FROM (SELECT TO_CHAR (record_date, 'yyyymmdd') rdate, count_value, ABS (FLOOR ( record_date - TO_DATE ('2006-07-04', 'yyyy-mm-dd') ) ) a FROM sql_test) t GROUP BY rdate, a ORDER BY a) b WHERE ROWNUM < 11
FROM (SELECT rdate, SUM (count_value), a
FROM (SELECT TO_CHAR (record_date, 'yyyymmdd') rdate, count_value,
ABS (FLOOR ( record_date
- TO_DATE ('2006-07-04', 'yyyy-mm-dd')
)
) a
FROM sql_test) t
GROUP BY rdate, a
ORDER BY a) b
WHERE ROWNUM < 11