David Garamond <[EMAIL PROTECTED]> wrote:
> We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
> numeric functions. Is it possible to use string functions as well? I
> know MIN() & MAX() can be asciibetical for string fields, but wouldn't
> this be very handy/practical?
>
> SELE
We can use SUM(), AVG(), COUNT(), etc. in GROUP clause. These are all
numeric functions. Is it possible to use string functions as well? I
know MIN() & MAX() can be asciibetical for string fields, but wouldn't
this be very handy/practical?
SELECT division,
G_CONCAT(", ",first_name) as nicks,