Skip to content
Snippets Groups Projects
Select Git revision
  • 1446720355e93c1e88779e69fa6e1e35ef8b4d9c
  • master default protected
  • cvh
  • main
4 results

README.md

Blame
  • 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=#