Skip to content
Snippets Groups Projects
Select Git revision
  • e5f77dbed1659b17ede018639a06063bc5dea51f
  • 2024ws default
  • 2023ws
  • 2022ws
  • 2021ws
  • 2020ws
  • 2018ws
  • 2019ws
  • 2017ws
  • 2016ws
10 results

trees-07.c

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