Further Options to Control Selection
TOP
Method SET_TOP( ) enables the number of hits to be restricted.
Example:
This means that only the first five logs found are returned as the result of the selection.
Skip
Method SET_SKIP( ) enables the selection results to be skipped.
Example:
The first ten logs found are skipped, and the first result returned is the eleventh hit in the database.
Order by
By default, the selection results are sorted by log number. If a different sorting is required, the relevant criteria can be passed to method SET_ORDERBY(.).
Example:
The identified logs are first sorted in descending order by user name and then sorted in ascending order by log number.