and answered many times on forums.mysql.com
> -----Original Message-----
> From: hsv@stripped [mailto:hsv@stripped]
> Sent: Thursday, November 29, 2012 5:40 PM
> To: mysql@stripped
> Subject: Re: Retrieve the values from the table of its max date
> >>>> 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....
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql