Wednesday, 4 May 2011

Praktikum 5 dan 6

SQL AGGREGATES

Examples of Aggregates








Aggregate with GROUP BY






GROUP BY with two columns







Combining SELECTs



Combining two tables with UNION







EXCEPT restricts output from the First SELECT



INTERSECT returns only duplicated rows



Creation of array columns



Large Objects (BLOBs)