From: Trimurthy
Date: November 29 2012 6:16am
Subject: Retrieve the values from the table of its max date
List-Archive: http://lists.mysql.com/mysql/228739
Message-Id: <345536cc$38ace4ae$e88751a$@com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0001_4FAEC4F8.257E311"

------=_NextPart_000_0001_4FAEC4F8.257E311
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

hi 
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.
please help me 

Thanks & Kind Regards,

 TRIMURTHY
 
   
 

------=_NextPart_000_0001_4FAEC4F8.257E311--