Subject | Re: [IBO] aggregate fields? Persistant fields? |
---|---|
Author | Paul Vinkenoog |
Post date | 2004-03-22T01:06:43Z |
Hi NN ;-)
select street, count( shop ) as num_shops
from shops
group by street
The output columns will be called STREET and NUM_SHOPS. Without the
alias num_shops the second column would have been called COUNT.
I think the right name is "column alias", not "SQL alias" like I said
in my previous post.
Greetings,
Paul Vinkenoog
> I will have to look into this. SQL alias? Is there an example ofI mean something like this:
> this somewhere?
select street, count( shop ) as num_shops
from shops
group by street
The output columns will be called STREET and NUM_SHOPS. Without the
alias num_shops the second column would have been called COUNT.
I think the right name is "column alias", not "SQL alias" like I said
in my previous post.
Greetings,
Paul Vinkenoog