COUNT function counts the number of rows retrieved by a SELECT statement. The return value is of type BIGINT. The COUNT(expr) function count the number of non-NULL values of expr in the rows retrieved by a SELECT statement. SELECT COUNT(expr) FROM tbl; In contrast, COUNT(*) is different in that it returns a count of the [...]
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.