PL/SQL help needed

[dragon99]

Sorry, should be
select unique(serviceid),max(msgdate) from messagearchive group by serviceid;