第一种排序方法:
利用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
- row_number row server number orderrow_number partition number order row_number row server number row_number rank dense_rank row_number函数 column row_number partition column1 dense_rank dense rank row_number row_number number rownum row row_number number mysql row row_number number row row_number postgresql函数amp