sql查询编号

2019独角兽企业重金招聘Python工程师标准>>>

 

 oracle 的rownum用法

 select rownum,id,name from student

 

 

sqlserver实现orcale rownum功能的

select  ROW_NUMBER() over(order by id desc) as num,* from tc_menu

select  ROW_NUMBER() over(order by id desc) as num,* from tc_menu

 

转载于:https://my.oschina.net/u/2377060/blog/787080