select count(*) from tablename t 2.select count(1) from tablename t 3.select last_value(ROWNUM) over() as TOTAL from tablename t
只统计数量，第二种最合适
select count(*) from tablename
select count(*) from 表名
