Complex PL-SQL Query ?

I have a table CIMSHIST that has fields: hullno, hulltype, location, asofdate.

I can have some data like the following

HULLTYPE HULLNO LOCATION ASOFDATE

--------  ------   --------   --------
YOS       33       700012/S   13-APR-95
YOS       33       700012/S   05-MAY-99
YOS       33       700012/S   10-JUL-02

I only want to return the record with
latest ASOFDATE.

Can anyone give me the SQL query to handle this task? Received on Tue Nov 19 2002 - 14:25:50 CST