Dear Oracle Usenets,

I am using Raptor to query an Oracle database.

here is an example DB

CODE Instances Day
100 27 Aug 18
101 30 Aug 18
102 10101 Aug 18
100 45 Aug 18
100 85 Aug 18
100 780 Aug 19
101 45 Aug 19

I want to run a query that gets a single row that sums the instances
field for only Code 100 from Aug 18th through Aug 19th. The key is, it
needs to be in a single row, because the actual table I am using has
millions of rows and it is not feasible to return all of them.

"Novs" <me (AT) scottsolomon (DOT) biz> wrote

select sum(instances) from mytable where code=100 and day

work? It will return 1 row. It will include the 19th which is what I
assume is what you want.
Jim