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