> At 06:59 AM 1/11/2007 -0800, you wrote: > >Depending on what column and type, you could do: > > > >select min(columnName), max(columnName) FROM table > > > >V/r, > >Charles
--- Emily Berk <[EMAIL PROTECTED]> wrote: > Right, because then I'm not doing two queries, yes? Your original description mentioned "first" and "last" not "smallest" and "largest". The UNION method I gave yesterday is still a single query. It returns two rows, however. The aggregate functions can be very time consuming depending on the size of the table, the type of data being evaluated, the entropy of the data, and indexing of the table. James Keeline
