HP3000-L Archives

October 1999, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
Re: ALLBASE "AS Clause" Enhancement - Your inputs required
From:
Jim Phillips <[log in to unmask]>
Reply To:
Jim Phillips <[log in to unmask]>
Date:
Fri, 22 Oct 1999 08:50:30 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (22 lines) 
Joe Geiser <[log in to unmask]> wrote:

<snip>

> Consider this my vote in the affirmative for an AS clause, as defined by
the
> standards.  The next to be looked at is the same problem with MAX(x),
> MIN(x), COUNT(x)... which also return EXPR(n).  This should probably be in
> the same area.

Or, one could scrap SQL altogether and use QueryCalc, which automatically
makes statistics (min, max, avg, count, sum, std dev) available on all
numeric fields retrieved in a query.

No <Plug>, just a happy user!


Jim Phillips                            Manager of Information Systems
E-Mail: [log in to unmask]     Therm-O-Link, Inc.
Phone: (330) 527-2124                   P. O. Box 285
  Fax: (330) 527-2123                   Garrettsville, Ohio  44231

ATOM RSS1 RSS2