Re: [sqlite] Selecting row containing max value

Bronislav Klučka wrote: Hi, I've got a table "state" which holds states for products, every insert made on this table is inserting values and value called "whenaction" where is the time (as timestamp) of the insert, so table cound look like this: id|amount|product_id|whenaction 1 50 2

[sqlite] Selecting row containing max value

Hi, I've got a table "state" which holds states for products, every insert made on this table is inserting values and value called "whenaction" where is the time (as timestamp) of the insert, so table cound look like this: id|amount|product_id|whenaction 1 50 2 115621 2 45 2