分頁原本都會用

SELECT COUNT(*) FROM ... WHERE ....

SELECT ... FROM ... WHERE LIMIT ...

MYSQL的話可以用SQL_CALC_FOUND_ROWS

SELECT SQL_CALC_FOUND_ROWS ... FROM ... WHERE LIMIT ...

在得到数据后，通过FOUND_ROWS()可以得到不带LIMIT的结果数：

SELECT FOUND_ROWS()

但聽說效率比較慢http://hi.baidu.com/thinkinginlamp/item/b122fdaea5ba23f614329b14

-------------------------------------------------------------------------

至於orcal或postgre可以用 COUNT(*) OVER()來組成分頁

SELECT *,COUNT(*) OVER() AS FULLROWCOUNT FROM ... WHERE ... LIMIT