All pastes #2131863 Raw Edit

Anonymous

public text v1 · immutable
#2131863 ·published 2012-03-24 22:39 UTC
rendered paste body
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;