从末端偏移/反向偏移? [英] Offset from end / reverse offset?

问题描述

是否可以从结束行获取偏移"?像是某种负偏移量?

Is it possible to get the "offset" from end row? Like some kind of negative offset maybe?

谢谢！

推荐答案

如果从限制/偏移"的意义上询问偏移，则传统方法是更改​​ORDER BY以反转结果.然后，OFFSET会从原始查询的末尾开始偏移.

If you are asking about offset in the "limit/offset" sense, the traditional way is to change your ORDER BY to reverse the results. Then OFFSET becomes offset from the end of the original query.

这篇关于从末端偏移/反向偏移?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！