DISTINCT: Returns available channel names and units.
TOP x: Selects top x files from a table and sort them ascending (ASC) or descending (DESC).
CASE: Displays results according to set conditions.
Advanced SELECT clauses (DISTINCT, TOP, CASE)
DISTINCT: Returns available channel names and units.
TOP x: Selects top x files from a table and sort them ascending (ASC) or descending (DESC).
CASE: Displays results according to set conditions.