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'!!
Hi Ian,
Glad you got it working - there are often subtle differences between
different flavours of SQL.
If you would like to track down the two blank records, you could try -
SELECT *
FROM `FedSaintsNew`.`Members` `Members`
WHERE `Members`.`Country` = ' '
Not sure what your syntax might be in
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 -
On 05/25/2013 08:37 AM, Dan Lewis wrote:
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