perhaps you are looking for something like
select entry,timestamp from table A where A.timestamp=(select max(B.timestamp)
from table B where a.entry=b.entry);
also this oage may be helpful:
http://www.artfulsoftware.com/infotree/queries.php
re,
wh
Am 30.11.2012 02:39, schrieb h...@tbbs.net:
and answered many times on forums.mysql.com
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Thursday, November 29, 2012 5:40 PM
> To: mysql@lists.mysql.com
> Subject: Re: Retrieve the values from the table of its max date
>
> >&g
2012/11/29 11:46 +0530, Trimurthy
i have a table which contains the columns
date,sname,age,item,quantity,units.my question is i want to retrieve all
the values from the table where date=maxdate group by sname how can i get
those values.
A question, I suspect, found in all SQL
