Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Count and list only where count is bigger than 1
- From: Mezei Zoltán <mezei(dot)zoltan(at)telefor(dot)hu>
- To: Ezequias Rodrigues da Rocha <ezequias(dot)rocha(at)gmail(dot)com>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Count and list only where count is bigger than 1
- Date: Tue, 19 Sep 2006 17:09:35 +0200
Ezequias Rodrigues da Rocha wrote:
SELECT distinct cli.bairro, COUNT( * ) as qtdGoogle/read tutorial for HAVING. E.g. SELECT distinct cli.bairro, COUNT( * ) as qtd FROM base.cliente cli GROUP BY cli.cidade, cli.bairro HAVING COUNT(*) > 1 Zizi |
- References:
- Count and list only where count is bigger than 1
- From: Ezequias Rodrigues da Rocha
- Count and list only where count is bigger than 1
- Prev by Date: Count and list only where count is bigger than 1
- Next by Date: Re: Count and list only where count is bigger than 1
- Previous by thread: Count and list only where count is bigger than 1
- Next by thread: Re: Count and list only where count is bigger than 1
- Indexes: