为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:8
【操作系统】：windows
【CPU】:
【问题描述】*：orcale转到达梦上，查询的时候报错
SQL语句： SELECT
distinct t.fld_code fldCode,
t.CHAPTER_NAME chapterName,
t.MXID mxid,
t.ALIKE_CODE alikeCode,
t.chapter_code chapterCode,
nvl(
(select DISPLAYNAME from FSTAID_APPHOME_ROLE s where
s.apphome_id = t.apphome_id
and s.DEPARTMENT_ID in ('460737103')
),t.fld_name) fldName,
(select MXID from fstaid_mb_mx where delete_flag = '0' and fld_code = chapter_code and mbid = mb_id) mbmxid,
(select SORT from FSTAID_APPHOME_ROLE s where
s.apphome_id = t.apphome_id
and s.DEPARTMENT_ID in
('460737103') ) sort,
(select mb_type from fstaid_mb where start_use_flag = '0' and delete_flag = '0' and mbid = mb_id) jiJiuType,
t.mb_id mbId,
t.xyld_fld_code xyldFldCode
FROM FSTAID_APPHOME_FLD t
WHERE DELETE_FLAG = '0'

ORDER BY to_number(mbid),TO_NUMBER(sort)

报错：-4062: 第23 行附近出现错误:
ORDER BY项不在DISTINCT查询项中