Counting how often each distinct entry appears in a database field

I have a Postgre database containing around 12 columns. Its fourth column is named column4. The database contains 120 rows and column4 can hold c4entry1, c4entry2, c4entry3...c4entry23, c4entry24. I'd like a printed table giving the frequency of every distinct value.

The resulting table would be something like:

Value(of column4)         frequency of that value
     c4entry1                        2
     c4entry2                        6
     c4entry3                        4
     c4entry4                        8
     c4entry5                        2
     c4entry6                        3
        .                            .
        .                            .
        .                            .

Which command would produce that output?

The conversation continues 2

Follow the reasoning

lichen14 Aug Permalink
Apply grouping to your chosen column, the one of interest here, then count the rows belonging to each resulting group:
```
SELECT column4, COUNT(*) FROM entries
GROUP BY column4
```
t.quill14 Aug Permalink
Combine the GROUP BY clause (http://www.network-theory.co.uk/docs/postgresql/vol1/TheGROUPBYandHAVINGClauses.html) with the aggregate COUNT() function (http://www.postgresql.org/docs/8.2/static/functions-aggregate.html):
```
SELECT column4, COUNT(column4) AS Frequency
FROM records GROUP BY column4
```

Counting how often each distinct entry appears in a database field

The conversation continues 2

Other sides of the same question

Missing field through a derived table in SQL

Testing D arrays for a matching entry

Removing an optional column safely with PostgreSQL 9+