Skip navigation links

MySQL Forums :: General :: Most Recent Date


Advanced Search

Most Recent Date
Posted by: Hisouka Deveza ()
Date: August 03, 2009 03:11AM

HI guys,

I have a Table here

Outlet--------Product-------Invoice-------Date------Quantity
4-------------101-----------1-------------1/1/2009--50
4-------------101-----------10------------2/1/2009--10
4-------------103-----------12------------3/1/2009--90
4-------------103-----------15------------1/1/2009--110

I need to query the Outlet, Product, Invoice Date, Quantity.. where the recent date of Group by Outlet and Product.. so i need to get the record of recentdate of outlet 4 product 101
and outlet 4 product 103.

SO it must output:


Outlet--------Product-------Invoice-------Date------Quantity
4-------------101-----------10------------2/1/2009--10
4-------------103-----------12------------3/1/2009--90

Because these was the recent date of group by Outlet and Product

Options: ReplyQuote


Subject Written By Posted
Most Recent Date Hisouka Deveza 08/03/2009 03:11AM
Re: Most Recent Date Peter Brawley 08/03/2009 08:40AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.