Skip to content
Snippets Groups Projects
Select Git revision
  • 3987a8b913efe4498f48bd0cc5811c23f4eef884
  • master default protected
  • v3-modify-mail
  • snyk-fix-207483a1e839c807f95a55077e86527d
  • translations_3b5aa4f3c755059914cfa23d7d2edcde_ru
  • translations_6e4a5e377a3e50f17e6402264fdbfcc6_ru
  • translations_3b5aa4f3c755059914cfa23d7d2edcde_fa_IR
  • translations_en-yml--master_fa_IR
  • snyk-fix-7d634f2eb65555f41bf06d6af930e812
  • translations_en-yml--master_ar
  • translations_3b5aa4f3c755059914cfa23d7d2edcde_el
  • jfederico-patch-1
  • v2
  • v3
  • v1
  • release-3.1.0.2
  • release-3.1.0.1
  • release-3.1.0
  • release-2.14.8.4
  • release-3.0.9.1
  • release-3.0.9
  • release-3.0.8.1
  • release-2.14.8.3
  • release-3.0.8
  • release-3.0.7.1
  • release-2.14.8.2
  • release-3.0.7
  • release-3.0.6.1
  • release-3.0.6
  • release-3.0.5.4
  • release-3.0.5.3
  • release-2.14.8.1
  • release-3.0.5.2
  • release-3.0.5.1
  • release-3.0.5
35 results

recordings_controller.rb

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