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']

  • No labels