在 SQL Server 中只用一个选择取倒数第二行?

2021-12-19 00:00:00 select 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.

相关文章