I think this will work SELECT sum(due) from mytable WHERE <whatever> ORDER BY cname || caddr GROUP BY cname || caddr
GROUP may have to come before ORDER, don't remember. On Thu, Jan 7, 2016 at 4:32 PM Dr. Hawkins <doch...@gmail.com> wrote: > I need to sum amounts and return keys where other fields are the same on an > in-memory database. > > I have my own unique key uniqDna, fields cname and cadr, and numeric field > due > > I want to SUM(due) for each unique cname||cadr, and get get the > corresponding keys. > > DISTINCT ON would due this, but it's not supported by SQLite. > > At the moment, I'm not seeing any approach other than returning them all, > and using cname||cadr as a matrix key, and summing myself. > > -- > Dr. Richard E. Hawkins, Esq. > (702) 508-8462 > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
