From: hsv
Date: November 30 2012 1:39am
Subject: Re: Retrieve the values from the table of its max date
List-Archive: http://lists.mysql.com/mysql/228744
Message-Id: <B0120931460@mailhome.tbbs.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

>>>> 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....