List:General Discussion« Previous MessageNext Message »
From:Rick James Date:November 30 2012 4:19pm
Subject:RE: Retrieve the values from the table of its max date
View as plain text  
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

Thread
Retrieve the values from the table of its max dateTrimurthy29 Nov
  • Re: Retrieve the values from the table of its max datehsv30 Nov
    • RE: Retrieve the values from the table of its max dateRick James30 Nov
    • Re: Retrieve the values from the table of its max datewalter harms30 Nov