Select a range of stuff?

Hi,

   I have the following query:

SELECT SUM(NUMERIC_COL) TOTAL FROM TABLE ORDER BY TOTAL DESC but I only want to extract a range of results (for example, the 1st through 10th rows the cursor returns, or the 31st through 40th). My initial thought was just to write a stored procedure and iterate through the cursor until I find the right range, but this seemed a little inefficient to me. Is there some way I can modify the above query so that the cursor will begin and end at a specified range?

Thanks in advance, Dave A. Received on Fri Mar 15 2002 - 13:20:50 CST