On Fri, Jan 13, 2012 at 6:22 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 13 Jan 2012, at 11:07am, Dilip Ranganathan wrote: > > > I have a table that looks like something like this: > > > > timestamp value person > > =============================================== > > 2010-01-12 00:00:00 33 emp1 > > 2010-01-12 11:00:00 22 emp1 > > 2010-01-12 09:00:00 16 emp2 > > 2010-01-12 08:00:00 16 emp2 > > 2010-01-12 12:12:00 45 emp3 > > 2010-01-12 13:44:00 64 emp4 > > 2010-01-12 06:00:00 33 emp1 > > 2010-01-12 15:00:00 12 emp5 > > > > I wanted to find the maximum value associated with each person. > > Do you have another table with your persons in it ? In other words, can > you do > > Unfortunately No. I am stuck with that one table. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
