DISTINCT

SELECT DISTINCT is used to select unique values from a set of data. This keyword returns distinct values from the output of the query.

The basic syntax for a SELECT DISTINCT statement is as followings:

  1. SELECT DISTINCT idc
  2. FROM system_metrics;

SELECT DISTINCT can be used in conjunction with filters.

  1. SELECT DISTINCT idc, host
  2. FROM system_metrics
  3. WHERE host != 'host2';

SELECT DISTINCT is a simple but powerful command of GreptimeDB SQL that allows users to easily condense the data into a summary of unique values. It can be used on one column or multiple columns, making it very versatile for data analysis and reporting. Using “SELECT DISTINCT” is a great way to get an overview of the types of data stored in the tables.