| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Thimble Smith | Date: | October 9 1999 8:25pm |
| Subject: | Re: count | ||
| View as plain text | |||
At 22:57, 19991008, Frank Oellien wrote:
>select CellID, count(NSCNr) from tgi group by CellID;
Frank, you want something like this:
select CellID, count(distinct NSCNr) from tgi group by CellID;
See a good SQL book, and the manual section on functions for use with
GROUP BY clauses.
Tim
| Thread | ||
|---|---|---|
| • count | Frank Oellien | 9 Oct |
| • Re: count | Martin Ramsch | 9 Oct |
| • Re: count | Thimble Smith | 9 Oct |