PostgreSQL: Catching bugs and hits

Question

PostgreSQL: Catching bugs and hits

Navigation

#1 by (3 votes)

0

I need a query to get the number of errors and hits from this table.

mysql sql query postgresql

asked by anonymous 15.05.2018 / 21:41

1 answer

How to insert new object into json file Date format in php [duplicate]

score 3 · Accepted Answer

Something like that:

SELECT t.acertou,
       COUNT(1)
  FROM tabela t
 GROUP BY t.acertou

If you wanted to show as just a record, you can use subquery :

SELECT (SELECT COUNT(1)
          FROM tabela t
         WHERE t.acertou) AS acertos,
       (SELECT COUNT(1)
          FROM tabela t
         WHERE NOT t.acertou) AS erros