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...
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.