请问这句SQL在Oracle里怎么写？

Question

SELECT LEN(RTRIM(Name))FROM Table1 GROUP BY LEN(RTRIM(Name)) ORDER BY LEN(RTRIM(Name))好象没有sum,max之类的函数.运行可能会出错
直接SELECT LEN(RTRIM(Name))FROM Table1  ORDER BY LEN(RTRIM(Name))
就可以了

Answer 1

SELECT LENGTH(RTRIM(Name))FROM Table1 GROUP BY LENGTH(RTRIM(Name)) ORDER BY LENGTH(RTRIM(Name))

Answer 2

SELECT LENGTH(RTRIM(Name))FROM Table1 
GROUP BY LENGTH(RTRIM(Name)) 
ORDER BY LENGTH(RTRIM(Name))"

Answer 3

select length(rtrim(name) from table1 order by length(trim(name))