为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】: 8
【操作系统】：win
【CPU】: x64
【问题描述】*: 嵌套查询中的order by无效
LAST_VALUE:无法解析的成员访问表达式[LAST_VALUE]
例如：ORDER BY 无效
SELECT NAME,FIRST_VALUE(SORT) FROM (
select "ID","NAME","SORT"
FROM "TEST"."TABLE_TEST"
ORDER BY SORT DESC
) GROUP BY NAME;
数据为：

结果为：

分割================================================
解决方案1：FIRST_VALUE(?) OVER(PARTITION BY ? ORDER BY ?) AS ?
SELECT ID,NAME,SORT FROM (
SELECT FIRST_VALUE(ID) OVER(PARTITION BY NAME ORDER BY SORT DESC) AS ID
,FIRST_VALUE(NAME) OVER(PARTITION BY NAME ORDER BY SORT DESC) AS NAME
,FIRST_VALUE(SORT) OVER(PARTITION BY NAME ORDER BY SORT DESC) AS SORT
FROM "TEST"."TABLE_TEST"
)
GROUP BY ID,NAME,SORT