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