Oracle group by后将group by字段合并成一行 SELECT NAME, property, ROW_NUMBER () OVER (ORDER BY property DESC) column_num FROM test