CREATE TABLE test (a INTEGER, b INTEGER, t TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO test VALUES (11, 22, 1), (13, 22, 2), (11, 21, 3), (11, 22, 4);

Affected Rows: 4

SELECT DISTINCT a, b FROM test ORDER BY a, b;

+----+----+
| a  | b  |
+----+----+
| 11 | 21 |
| 11 | 22 |
| 13 | 22 |
+----+----+

SELECT DISTINCT test.a, b FROM test ORDER BY a, b;

+----+----+
| a  | b  |
+----+----+
| 11 | 21 |
| 11 | 22 |
| 13 | 22 |
+----+----+

SELECT DISTINCT a FROM test ORDER BY a;

+----+
| a  |
+----+
| 11 |
| 13 |
+----+

SELECT DISTINCT b FROM test ORDER BY b;

+----+
| b  |
+----+
| 21 |
| 22 |
+----+

SELECT DISTINCT a, SUM(B) FROM test GROUP BY a ORDER BY a;

+----+-------------+
| a  | SUM(test.b) |
+----+-------------+
| 11 | 65          |
| 13 | 22          |
+----+-------------+

SELECT DISTINCT MAX(b) FROM test GROUP BY a;

+-------------+
| MAX(test.b) |
+-------------+
| 22          |
+-------------+

SELECT DISTINCT CASE WHEN a > 11 THEN 11 ELSE a END FROM test;

+-------------------------------------------------------------+
| CASE WHEN test.a > Int64(11) THEN Int64(11) ELSE test.a END |
+-------------------------------------------------------------+
| 11                                                          |
+-------------------------------------------------------------+

DROP TABLE test;

Affected Rows: 0