>Hi Guys,
>
>I have an SQL table named itemledger which contains 3 columns (itemid,whcode,docdate). The table consist of records having the same itemid and whcode but with different docdate.
>
>Example:
>
>001 MIS      08/01/2005
>001 MIS      08/15/2005
>001 ACCT   09/08/2005
>001 ACCT   09/15/2005
>
>From here, I want to query this table to return the grouped itemid & whcode with the latest dodate.
>
>Expected Result from the query:
>001 MIS      08/15/2005
>001 ACCT   09/15/2005
>
>Is there a way to formulate a Query Statement that would return these results?
>
>Thanks in Advance...

SELECT itemid,whcode,MAX(docdate) max_docdate FROM table group by itemid,whcode