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;