Re: [libreoffice-users] LO Base - Question about Query [SOLVED]

On 05/25/2013 07:10 AM, Ian Whitfield wrote:
> Thanks Noel !!!
>
> On 25/05/13 11:58, Marion & Noel Lodge wrote:
> > Assuming your field is 'Country', try this -
> >
> >     SELECT Country, Count(Country) AS 'Count'
> >     FROM <your Table name>
> >     GROUP BY Country
> >     ORDER BY Country
> I had a problem, at first - as I always seem to do - with 'Syntax 
> Error'!! So I created it with the Wizard and edited it in SQL view.
>
> This resulted in ...
>
> SELECT `Members`.`Country` AS `Country`
> FROM `FedSaintsNew`.`Members` `Members`
> GROUP BY `Members`.`Country`
> ORDER BY `Members`.`Country`
>
> This worked 100%!! So thanks very much. It does bring up two 'Blank' 
> results, (which I guess must have a space in them or something). I 
> don't know how to track these down but it's not too important.
>
> Appreciate the help.
>
> IanW
> Pretoria RSA
     If all you want is a count of the distinct countries in your 
table, try this:

SELECT COUNT( DISTINCT `Members`.`Country`) AS `Country`
FROM `FedSaintsNew`.`Members` `Members`

--Dan

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted