VistaDB 5
Gibraltar VistaDB / Developer's Guide / SQL Reference / Functions / Aggregate Functions / COUNT_BIG
In This Topic
    COUNT_BIG
    In This Topic
    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