您可以将行row_number()两次，然后取出终端箱

select Taille_caractere, Valeur_ASCII
from (
    SELECT FIRST_NAME ||' '|| LAST_NAME FULL_NAME ,
           (LENGTH(FIRST_NAME ||' '|| LAST_NAME)-1) Taille_caractere , 
           (ascii(FIRST_NAME ||' '|| LAST_NAME)-1)  Valeur_ASCII,
      row_number() over(order by LENGTH(FIRST_NAME ||' '|| LAST_NAME), FIRST_NAME ||' '|| LAST_NAME) rn1,
      row_number() over(order by LENGTH(FIRST_NAME ||' '|| LAST_NAME) DESC, FIRST_NAME ||' '|| LAST_NAME) rn2,
      FROM EMPLOYEES
) t
where rn1 = 1 or rn2 = 1;

这是给你的：

WITH cteEmployees
  AS (SELECT FIRST_NAME,
             LAST_NAME,
             FIRST_NAME || ' ' || LAST_NAME AS FULL_NAME,
             LENGTH(FIRST_NAME || ' ' || LAST_NAME) AS FULL_NAME_LENGTH
        FROM EMPLOYEES),
  cteLeast AS
     (SELECT *
        FROM (SELECT *
                FROM cteEmployees
                ORDER BY FULL_NAME_LENGTH ASC,
                         LAST_NAME ASC,
                         FIRST_NAME ASC)
        WHERE ROWNUM = 1),
  cteMost AS
     (SELECT *
        FROM (SELECT *
                FROM cteEmployees
                ORDER BY FULL_NAME_LENGTH DESC,
                         LAST_NAME ASC,
                         FIRST_NAME ASC)
        WHERE ROWNUM = 1)
SELECT *
  FROM cteLeast
UNION ALL
SELECT *
  FROM cteMost

我把决定名字的ASCII值的问题留给你们，因为我不明白那是什么意思。