Skip to content
Snippets Groups Projects
Select Git revision
  • 4123014b9d995f28dc1b9df1a7fae593c7f77e46
  • 2024ws default protected
  • 2023ws
3 results

dbms-12.txt

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