DISTINCT

SELECT DISTINCT removes duplicate rows from a query result. When the select list contains multiple expressions, rows are considered duplicates only when the complete set of selected values is equal.

The following query returns each distinct idc value:

SELECT DISTINCT idc
FROM system_metrics;

DISTINCT is applied to the rows that satisfy the WHERE clause:

SELECT DISTINCT idc, host
FROM system_metrics
WHERE host != 'host2';