select A from select TCODE TNAME TO_CHARwm_concatREAL_NAME MOBILE_TELEPHONE MOBILE_TELEPHONETSUPERIOR_ID select name from t_Sys_Organization where id = TSUPERIOR_ID as zgnamese

To sort the result by the "code" column without considering the length of the code, you can use the ORDER BY clause with the LENGTH function. Here's an updated version of the query:

SELECT A.* FROM ( SELECT T.CODE, T.NAME, TO_CHAR(wm_concat(REAL_NAME || ' : ' || MOBILE_TELEPHONE)) MOBILE_TELEPHONE, T.SUPERIOR_ID, (SELECT name FROM t_Sys_Organization WHERE id = T.SUPERIOR_ID) AS zgname, (SELECT TO_CHAR(wm_concat(REAL_NAME || ' : ' || MOBILE_TELEPHONE)) FROM t_sys_user WHERE DEFAULT_ORGANIZATION_ID = SUPERIOR_ID) AS zglxr FROM t_sys_user K JOIN t_Sys_Organization T ON K.DEFAULT_ORGANIZATION_ID = T.ID JOIN B001 ON T.id = B001.B001id WHERE t.code LIKE '3301' || '%' AND B001043 = '1' GROUP BY T.CODE, T.NAME, T.SUPERIOR_ID, DEFAULT_ORGANIZATION_ID ) A GROUP BY code, name, MOBILE_TELEPHONE, zgname, SUPERIOR_ID, zglxr ORDER BY LENGTH(code), code;