VistaDB 5
COUNT_BIG
COUNT_BIG returns the number of items in the current SELECT statement. This includes NULL values and duplicates.



Remarks

Function works the same as COUNT() but returns a BIGINT as the return type. See the COUNT topic for more examples and information.

Example

SELECT COUNT_BIG(*) FROM table
 
SELECT COUNT_BIG(DISTINCT column) FROM table
See Also