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+unsubscr...@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
