Query in HQL using Hibernate

Question

Query in HQL using Hibernate

Navigation

#1 by (1 votes)

0

How to make a query to return the result to below in HQL

Result

| quantidade | quantidade erro |   desc   |

|     2      |         1       |  TESTE 1 |
|     3      |         2       |  TESTE 2 |
|     1      |         1       |  TESTE 3 |

Table

| DESC    |  ERRO |

| TESTE 1 |   0   |
| TESTE 1 |   1   |
| TESTE 2 |   1   |
| TESTE 2 |   0   |
| TESTE 2 |   1   |
| TESTE 3 |   1   |

java hibernate hql

asked by anonymous 06.07.2015 / 16:38

1 answer

PHP script that for a service in the operating system Sending a link via email with PHPMailer

score 1 · Answer 1

You need to group the data by Description and make a count ( count ) for the grouped quantity, then a SUM to count the number of errors - ERRO , and at the end append the description:

SELECT COUNT(*) as quantidade, SUM(ERRO) as quantidadeErro, desc
FROM tabela
GROUP BY DESC