Hi,
You've mentioned First as used for sampling data at least twice now. This
is not an sql standard and I've never heard of it before. Who uses it like
this?

david jencks

On 2001.06.01 12:30:14 -0400 Peter Morris wrote:
> > SELECT ALL <field list> FROM <tables> .... for fast full
> > SELECT <field list> FROM <tables> .... for fast first
>
> Yuk.
>
> I think you are describing the difference between FIRST (used for
> sampling
> data) and TOP (which processes all data, but only returns the TOP "X"
> results).
>
> Pete
> ===
> http://www.HowToDoThings.com
>
>
> Community email addresses:
> Post message: IBDI@yahoogroups.com
> Subscribe: IBDI-subscribe@yahoogroups.com
> Unsubscribe: IBDI-unsubscribe@yahoogroups.com
> List owner: IBDI-owner@yahoogroups.com
>
> Shortcut URL to this page:
> http://www.yahoogroups.com/community/IBDI
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>