Limiting results of a query to a range of rows

Hi,
  Say you have a query such as;

      SELECT * FROM widgets ORDER BY widget_id;

Is there a way to alter the above query so that it only returns rows 1 through 10, or 11 through 20 of the results? The query may also have where clauses such that saying

WHERE widget_id >= 1 AND widget_id <= 10

might not be valid to get what I'm asking for. Thanks for any help.

--
David F. Newman
dave.newman_at_webct.com