From: Rick James
Date: November 30 2012 4:19pm
Subject: RE: Retrieve the values from the table of its max date
List-Archive: http://lists.mysql.com/mysql/228745
Message-Id: <582AFBFC517D194489EF570FE21694CF07026B62@GQ1-EX10-MB03.y.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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
>=20
> >>>> 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=3Dmaxdate group by sname how can
> i get those values.
> <<<<<<<<
> A question, I suspect, found in all SQL courses....
>=20
>=20
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql