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 > > >>>> 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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql