求助，FM中提取最大值

xiaoerp

在FM建模的时候，有Actor和Timestamp两列，每个Actor有多个Timestamp，我想用MAX取出每个Actor对应的最大的Timestamp。
在Query Subject Definition中我修改SQL定义如下：
Select
        EMT_LOG.ACTOR,
        max(EMT_LOG."TIMESTAMP") as EMT_LOG.TIMESTAMP
From
        [PTTEMTV].EMT_LOG as EMT_LOG

Group by EMT_LOG.ACTOR

但是出现如下错误：
The query contains an error.
You can save the object and edit it later, but other objects that reference it may be affected by this update.

Do you wish to save your changes?

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-16'.
UDA-SQL-0358 Line 3: Syntax error near ".".

希望哪位大虾给指点一下~谢谢~太谢谢了！

xiaoerp

语法错误啦！

  max(EMT_LOG."TIMESTAMP") as EMT_LOG.TIMESTAMP
不要引号试试呀！