如何选择最底端的行? [英] How to select bottom most rows?

问题描述

我可以选择SELECT TOP(200)...但是为什么不能下(200)?

I can do SELECT TOP (200) ... but why not BOTTOM (200)?

难道不是我的意思是什么，我怎么能做相当于TOP(200)但相反(从底部开始，就像您希望BOTTOM会做的那样...)?

Well not to get into philosophy what I mean is, how can I do the equivalent of TOP (200) but in reverse (from the bottom, like you'd expect BOTTOM to do...)?

推荐答案

SELECT
    columns
FROM
(
     SELECT TOP 200
          columns
     FROM
          My_Table
     ORDER BY
          a_column DESC
) SQ
ORDER BY
     a_column ASC

这篇关于如何选择最底端的行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！