Re: [SQL] Table Sorting and Limit Question

2002-08-09 Thread Dawn Hollingsworth
ffset into the query would contain the id I'm interested in. Dawn Hollingsworth Principal Engineer AirDefense, Inc. On Thu, 2002-08-08 at 21:42, Ludwig Lim wrote: > > --- Dawn Hollingsworth <[EMAIL PROTECTED]> wrote: > > > > > > Currently we have a tab

[SQL] Table Sorting and Limit Question

2002-08-08 Thread Dawn Hollingsworth
sort the table by date but pull out the hundred row set that contains id say...542 for example. What would be the best way to do this taking into account this table is several hundred thousand rows? Dawn Hollingsworth Principal Engineer AirDefense, Inc. ---(end of