I am trying to build a query in Slx to show me all of the accounts that had a meeting, and when that last meeting was. So far the closest I have gotten it to work is using this under Historyid with the 'in' operator:

SELECT A3.HISTORYID FROM HISTORY A3 WHERE A3.TYPE = 262145 AND A3.COMPLETEDDATE = (SELECT MAX(A4.COMPLETEDDATE) FROM HISTORY A4 WHERE A4.ACCOUNTID = A3.ACCOUNTID) 

You'll need to group the results for it to be accurate. A sub-query won't cut it. Try something like this:

select 
	  AccountID
	, max(completeddate) as LastMeetingDate  
from 
	sysdba.history 
where 
	type = 262145 
group by
	accountid