The same result with count(*)

Summary
You can get the same result with count(*) with the query:
SELECT NVL(MAX(ROWNUM),0)
FROM RANDOM_VALUES;
It will count rows to table RANDOM_VALUES like
SELECT COUNT(*) FROM RANDOM_VALUES;
Reviews
Filters
Search