MIN
Descriptionβ
The MIN function returns the minimum non-NULL value of the expression.
Syntaxβ
MIN(<expr>)
Parametersβ
Parameters | Description |
---|---|
<expr> | The expression to get the value. Supported types are String, Time, Date, DateTime, IPv4, IPv6, TinyInt, SmallInt, Integer, BigInt, LargeInt, Float, Double, Decimal. |
Return Valueβ
Returns the same data type as the input expression. If all records in the group are NULL, the function returns NULL.
Exampleβ
-- setup
create table t1(
k1 int,
k_string varchar(100),
k_decimal decimal(10, 2)
) distributed by hash (k1) buckets 1
properties ("replication_num"="1");
insert into t1 values
(1, 'apple', 10.01),
(1, 'banana', 20.02),
(2, 'orange', 30.03),
(2, null, null),
(3, null, null);
select k1, min(k_string) from t1 group by k1;
String type: For each group, returns the minimum string value.
+------+---------------+
| k1 | min(k_string) |
+------+---------------+
| 1 | apple |
| 2 | orange |
| 3 | NULL |
+------+---------------+
select k1, min(k_decimal) from t1 group by k1;
Decimal type: Returns the minimum high-precision decimal value.
+------+----------------+
| k1 | min(k_decimal) |
+------+----------------+
| 1 | 10.01 |
| 2 | 30.03 |
| 3 | NULL |
+------+----------------+
select min(k_string) from t1 where k1 = 3;
When all values in the group are NULL, returns NULL.
+---------------+
| min(k_string) |
+---------------+
| NULL |
+---------------+
select min(k_string) from t1;
Minimum value of all data.
+---------------+
| min(k_string) |
+---------------+
| apple |
+---------------+