Count( field_name | * | 1 ) counts the number of non null data rows in the selection.
Example:
SELECT COUNT ( fieldname) FROM table_a
[WHERE field2 = ‘test’]
Count( field_name | * | 1 ) counts the number of non null data rows in the selection.
Example:
SELECT COUNT ( fieldname) FROM table_a
[WHERE field2 = ‘test’]
Comments
Please sign in to leave a comment.