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
countFrank Oellien9 Oct
  • Re: countMartin Ramsch9 Oct
  • Re: countThimble Smith9 Oct