第一种排序方法:
利用row_number() over(order by createtime desc) as row
参考来源:
版权声明:本文为CSDN博主「云游的二狗」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/missingshirely/article/details/44037037
语法如下:
select * from (
select *, ROW_NUMBER() OVER(Order by a.CreateTime DESC ) AS RowNumber from table_name as a
) as b
where RowNumber BETWEEN 1 and 5
标签:over,number,RowNumber,排序,order,row From: https://www.cnblogs.com/zhangbupangpang/p/17814869.html