Select Git revision
dbms-12.txt
Forked from
Peter Gerwinski / Datenbanken und Datensicherheit
89 commits behind the upstream repository.
Peter Gerwinski authored
dbms-12.txt 1.50 KiB
testdb=# SELECT tierart, COUNT(*) FROM tier GROUP by tierart;
tierart | count
--------------------------------+-------
Spinne | 2
Hund | 1
Ratte | 1
Katze | 2
(4 Zeilen)
testdb=# SELECT tierart, COUNT(id) FROM tier GROUP by tierart;
tierart | count
--------------------------------+-------
Spinne | 2
Hund | 1
Ratte | 0
Katze | 1
(4 Zeilen)
testdb=# SELECT tierart, MAX(id) FROM tier GROUP by tierart;
tierart | max
--------------------------------+-----
Spinne | 4
Hund | 2
Ratte |
Katze | 3
(4 Zeilen)
testdb=# SELECT tierart, MAX(id) FROM tier GROUP BY tierart;
tierart | max
--------------------------------+-----
Spinne | 4
Hund | 2
Ratte |
Katze | 3
(4 Zeilen)
testdb=# SELECT tierart, SUM(id) FROM tier GROUP BY tierart;
tierart | sum
--------------------------------+-----
Spinne | 5
Hund | 2
Ratte |
Katze | 3
(4 Zeilen)
testdb=#