I have a field in a table called DAILY_COUNT that holds the value of page hits for a day. The next day a new record is added and begins counting up for that day. How do I write a query that adds up the total of every day into one value.
SELECT TOTAL_OF_ALL_DAYS(daily_count) AS page_hits -- ;-)
WHERE page_id = 1