摘要： ROW_NUMBER必须指写over (order by **)，有时我根本就不想排序，想按原始顺序 select ROW_NUMBER() over(order by (select 0)) AS ROWNUM,* FROM t 阅读全文