ps122

导航

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

 

posted on 2016-07-20 16:27  ps122  阅读(115)  评论(0编辑  收藏  举报