本文介绍了在 SQL Server 中只用一个选择取倒数第二行?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我试图用 SQL Server 选择倒数第二行.所以我写了一个这样的查询:
I was trying to select the second last row with SQL Server. So I wrote a query like this:
SELECT TOP 1 * From Cinema
WHERE CinemaID!=(SELECT TOP 1 CinemaID
FROM Cinema
ORDER BY CinemaID DESC)
ORDER BY CinemaID DESC
它做了我需要的.但我只想用一个选择做同样的事情.
and it did what I need. But I want to do the same thing with only one select.
我读到 MySql 中的 LIMIT 子句就是这样做的.但我找不到任何等价物其中.所以我很感激任何帮助找到有用的东西.
I read that the LIMIT clause in MySql does that. But I couldn't find any equivalent of that. So I appreciate any help about finding something useful.
推荐答案
要在一次选择中获取倒数第二行:
To get the 2nd last row in one select:
SELECT TOP 1 * From
(select Top 2 * from Cinema ORDER BY CinemaID DESC) x
ORDER BY CinemaID
实际上只有一个"选择，因为外部选择仅超过 2 行.
It's really only "one" select because the outer select is over only 2 rows.
这篇关于在 SQL Server 中只用一个选择取倒数第二行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！