Re: [PHP-DB] GROUP BY with a string column From: Martín Marqués (martin <email protected>)
Date: 11/28/01

On Mié 28 Nov 2001 19:42, you wrote:
> Can the SUM keyword in SELECT be generalized to strings?
>
> A tipical use for the SUM keyword is:
>
> SELECT column1, SUM(column2)
> FROM table
> GROUP BY column1
>
> This works only if column2 contains numbers (and SUM is the mathematical
> sum).
>
> What about obtain the same behaviour, when column2 contains strings (and
> SUM is string concatenation)?

With which database engine?

-- 
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués                  |        mmarques <email protected>
Programador, Administrador, DBA |       Centro de Telematica
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>