How can I sum number of rows of a table in SQL ORACLE?
Posted
by
Christian Magro
on Stack Overflow
See other posts from Stack Overflow
or by Christian Magro
Published on 2012-11-21T16:55:43Z
Indexed on
2012/11/21
16:59 UTC
Read the original article
Hit count: 243
Dear community I have the follow instruction on SQL ORACLE:
SELECT COUNT(FE_DAY)
FROM TI_DATE
WHERE (FE_MO = 02 AND FE_YEAR in ('2011', '2012'))
GROUP BY FE_DAY
In this instruction effectively obtain like SQL Answer a list of number that they sum=10 .But How can I don't show rows .I need only show the row's sum=10
I tried to apply the follow SQL instruction also:
SELECT SUM(COUNT(FE_DAY))
FROM TI_DATE
WHERE (FE_MO = 02 AND FE_YEAR in ('2011', '2012'))
GROUP BY FE_DAY
But the answer was 57, different of the number of rows, that I need.
© Stack Overflow or respective owner
