Re: counting sheeps
| From: | Martín Marqués | Date: | Mon, 29 Oct 2001 23:02:52 +0000 |
| Subject: | Re: counting sheeps | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-72791@lists.php.net to get a copy of this message | ||
On Lun 29 Oct 2001 19:34, Frewuill Rodriguez wrote:
> the quey should be something like this
>
> select count(fieldname) from table where id = name
No, the answer is:
select DISTINCT count(fieldname), fieldname from table GROUP BY fieldname
Saludos... :-)
--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques@unl.edu.ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------