select * , count(*) over () as rowcount from t ;