In this section, you take a close look at how data can be classified with the help of joins and tables. In general, classification means that certain values are combined in one group , which is assigned to a new name . How can you tell the database which values have to be combined? The problem can be solved in several ways. The following table shows you how classification and aggregation can be done with PostgreSQL:
|