From: walter harms
Date: November 30 2012 4:55pm
Subject: Re: Retrieve the values from the table of its max date
List-Archive: http://lists.mysql.com/mysql/228746
Message-Id: <50B8E500.7010908@bfs.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

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 hsv@stripped:
>>>>> 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 courses....
> 
>