Forum: MySQL  Jul 16th, 2009 |
| Replies: 3 Views: 426 SELECT
info.SiteId ,
info.Alias,
info.Code,
info.NewID,
count(info.Longitude),
count(info.Lat),
info.Address,
info.Region,
info.City, |
| Forum: MySQL Jul 16th, 2009 |
| Replies: 3 Views: 426 Hi, I am using this query for count
SELECT Count(ID) from Table
But its showing the count of all the fields which are empty and zeros. I want the count of fields which are empty and zero. please... |
