...
Code Block | ||
---|---|---|
| ||
-- Select all invoices and their score value where the field 'status' either contains 'reminder', -- 'discount' or 'delay', with the result list sorted in ascending order of alias s (score value). SELECT *,SCORE() s FROM invoice WHERE status CONTAINS('reminder discount delay') ORDER BY s ASC; |
Aggregations
GROUP BY and COUNT(*) Function
To determine the number of objects with special properties, queries can be aggregated. All objects with the same entry in the field specified after the GROUP BY clause are summarized. The number of objects is returned to the field 'OBJECT_COUNT' without the assignment of aliases.
...
It is possible to set an alias as under which the SUM()
result will be displayed.
...