|
Compatibility
| COUNT(f) |
| Engine |
OK |
Alternative |
| ingres |
yes |
|
| mysql |
yes |
|
| oracle |
yes |
|
| postgres |
yes |
|
| sqlserver |
yes |
|
COUNTCOUNT finds the number of non-null values in a column. COUNT is an aggregate function
it is normally used with GROUP BY.
SELECT region, COUNT(name)
FROM bbc
GROUP BY region
With a GROUP BY region statement each region shows up
just once. The COUNT column gives the number of countries for each region.
|
Results
|
See also: | |