mysql - 如何计算 SQL 查询有限结果集中的行数？

Question

我只想使用一个条件从数据库表中获取 20 行例如:

select * from orders where price > 10000 limit 0,20

以上查询将只获取 20 行。当 limit 0,20 未使用时，有什么方法可以让我在 WHERE 子句中以相同条件获取多少行？我必须在一个查询中完成。

请指导我。

谢谢..

Answer 1

引用MySQL docs :

A SELECT statement may include a LIMIT clause to restrict the number of rows the server returns to the client. In some cases, it is desirable to know how many rows the statement would have returned without the LIMIT, but without running the statement again. To obtain this row count, include a SQL_CALC_FOUND_ROWS option in the SELECT statement, and then invoke FOUND_ROWS() afterward.