New answers tagged count
5
votes
Not getting the concept of COUNT with GROUP BY?
The COUNT() function is an aggregate function that returns the number of rows in a table. The COUNT() function allows you to count all rows or only rows that match a specified condition.
The COUNT() ...
1
vote
question regarding count function
You just need to add State to the GROUP BY and your projected columns to get the parent state for each county (e.g. "Florida" for Miami Dade).
SELECT state,
county,
count(*) AS ...
1
vote
SQL: Count number of distinct records based on attribute value in an xml
Don't force it into RAM; let it use disk as needed. Do you have it in a table? Or only in XML?
There is probably a single LOAD DATA statement to convert that from XML to a table defined thus:
CREATE ...
Top 50 recent answers are included
Related Tags
count × 433mysql × 171
postgresql × 106
join × 66
group-by × 62
sql-server × 61
select × 43
performance × 36
query × 27
oracle × 26
aggregate × 21
distinct × 19
query-performance × 18
index × 18
subquery × 18
sum × 13
null × 12
postgresql-performance × 11
where × 11
window-functions × 9
innodb × 8
mariadb × 8
optimization × 8
trigger × 8
update × 8