On 12/14/2011 9:38 PM, Dilip Ranganathan wrote:
Thanks. Along the same lines, I have another question. I have a table like
this:
timestamp | category | col1 | col2
========================
xx CAT1 3 5
yy CAT1 5 6
zz CAT3 2 9
rr CAT3 4 3
I wanted to find the latest entry for every category based on their
timestamp. The records in the table are always inserted in such a way that
the last record always has the latest timestamp.
In my first pass, I mistakenly wrote the query like this: (assume timestamp
is stored as julian days)
select timestamp, category, col, col2 from table group by category order by
timestamp desc
This query doesn't make sense since after the grouping I am not specifying
anywhere which record is be chosen out of the grouped lot. Yet the result
was like this:
yy CAT1 5 6
rr CAT3 4 3
Is it that from the grouped records, sqlite automatically chooses the
latest inserted record?
It might happen to fall out of the implementation. Personally, I
wouldn't rely on it.
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
