How can I sum number of rows of a table in SQL ORACLE?
- by Christian Magro
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.
