MySQL:如何从表中选择除最后一行以外的所有行 [英] MySQL: How to select all rows from a table EXCEPT the last one

问题描述

我有一个包含N行的表，我想选择N-1行.

I have a table with N rows, and I wanna select N-1 rows.

如果可能的话，建议在一个查询中执行此操作.

Suggestions on how to do this in one query, if it's possible..?

推荐答案

最后一行的ID是否最高?如果是这样，我认为这会起作用:

Does the last row have the highest ID? If so, I think this would work:

SELECT * FROM TABLE WHERE ID != (SELECT MAX(ID) FROM TABLE)

MySQL确实允许在当前版本中进行子选择，对吧?

MySQL does allow subselects in the current version, right?

但是，在大多数情况下，如果选择了所有行，然后在应用程序中过滤掉了不需要的数据，它的性能可能会更好.

However, in most cases, it'd probably perform better if you selected all the rows and then filtered the unwanted data out in your application.

这篇关于MySQL:如何从表中选择除最后一行以外的所有行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！