Skip to content
Snippets Groups Projects
Select Git revision
  • b1167b8ba1257a45763ea22f902e4540f26469ae
  • 2024ss default
  • 2023ss
  • 2022ss
  • 2021ss protected
5 results

blink-01.hex

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