2022-04-25 oracle11g 今天做了一个销售数据的排序,是再Oracle11g版本下的。sql如下 SELECT T.* FROM ( SELECT row_number() over(order by A.LASTWEEK_QTY DESC) as id LASTWEEK_QTY FROM A )T WHERE T