使用窗口函数row_number()
select row_number() OVER (ORDER BY id) as rownum ,* from score;
如果不关心排序,可以这样select row_number() over() as rownum,* from score;
————————————————
版权声明:本文为CSDN博主「tanweii163」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/tanweii163/article/details/14522463