Hi Ian, Assuming your field is 'Country', try this -
SELECT Country, Count(Country) AS 'Count' FROM <your Table name> GROUP BY Country ORDER BY Country Noel -- Noel Lodge [email protected] On 25 May 2013 19:09, Ian Whitfield <[email protected]> wrote: > Hi All > > I have a Database with about 3000 addresses in it and need - from > time-to-time - to check how many different Countries are listed in it. > > I have a Query that extracts this for me but naturally it pulls out EVERY > entry for EVERY Country. > > Is there a way for a Query to do this BUT only list each Country Once?? > > (PCLOS 2013, MySQL 5.1.55, LO 3.6.5.2) > > Thanks for any help > > IanW > Pretoria RSA > > -- > To unsubscribe e-mail to: > users+unsubscribe@global.**libreoffice.org<users%[email protected]> > Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > unsubscribe/<http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > Posting guidelines + more: http://wiki.**documentfoundation.org/** > Netiquette <http://wiki.documentfoundation.org/Netiquette> > List archive: > http://listarchives.**libreoffice.org/global/users/<http://listarchives.libreoffice.org/global/users/> > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: [email protected] 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
