如何在sql排序后给排好的数据加序号

select 学号,日期,row_number() over(partition by 学号 order by  学号) from A表;
Mysql利用用户变量rowno获取排序后的序号，相当于Oracle的伪列
select id,score,(@rowno:[email protected]+) as rowno from test,(select (@rowno:=)) b order by score desc;
注：@rowno:=0，用@定义,表示rowno变量的初始值为0。

--组内排序
SELECT id,te FROM test ORDER BY te DESC,id DESC;

--组内排序加自动列（序号-相当于表的行号，从1开始）
SELECT id,te,(@rowno:[email protected]+) AS rowno FROM test,(SELECT (@rowno:=)) b ORDER BY te DESC,id DESC;

--组内排序加自动列（序号-每组从1开始）
SELECT id,te,rank FROM
(SELECT t.id,t.te,@rownum:[email protected]+,IF(@i=t.te,@rank:[email protected]+,@rank:=) AS rank,@i:=t.te FROM
(SELECT id,te FROM test ORDER BY te ASC,id DESC) t ,(SELECT @rownum := , @i := NULL ,@rank:=) a
) result ;