Anonymous

SELECT *  FROM (       SELECT *         FROM sales        WHERE sale_date <= ?          AND NOT (sale_date = ? AND sale_id >= ?)        ORDER BY sale_date DESC, sale_id DESC       ) WHERE rownum <= 10;