Home -
General /
All posts - M8 SQL syntax select sum/group by
|
Sorry, very basic! Referencing a points drawing with columns Site holding values 0 or 1 and Habitat I wish to sum Site grouped by Habitat. The following lists the totals only. What is the syntax to include the matching Habitat in the resulting table? select sum([Site]) as Total from [Drawing] group by [Habitat]; Thanks
Aussie Nature Shots |
|
Just SELECT [Habitat], SUM([Site]) AS [Total]...
|