Re: SQL: How to select first N rows?

In article <66h1l9$pj1@cssun.mathcs.emory.edu>, James T Ford <James_T_Ford@fleet.com> writes > is this a synonym for greasy??? > > > anyhow - for this problem > select rows into a temp table with a serial column > select from temp where serial < # > This *will* select the first N rows - but the query will have to run to completion to populate the temp table which may take some time! -- Sally Woolrich My Email address has been altered to limit junk mail. Please remove the second 'x' in the company name to Email me.