Tencent Cloud TCHouse-P Comparison of Row Value and Array-Development Guide-Help & Documentation-Tencent Cloud

Operator
Description
Sample code
Result
IN
Consistent with Subquery IN
select * from t1 where a1 in (2,5,6);
a1
----
2
(1 row)
NOT IN
Consistent with Subquery NOT IN
select * from t1 where a1 not in (2,5,6);
a1 
----
1
3
(2 rows)
ANY/SOME
If at least one comparison result is TRUE, it returns TRUE; otherwise, it returns FALSE
select * from t1 where a1 < any(array[1,3]);
a1 
---- 
2
1
(2 rows)
ALL
If all comparison results are TRUE, it returns TRUE; otherwise, it returns FALSE
select * from t1 where a1 < ALL(array[3]);
a1 
----
2
1
(2 rows)
﻿

Operator	Description	Sample code	Result
IN	Consistent with Subquery IN	select * from t1 where a1 in (2,5,6);	a1 ---- 2 (1 row)
NOT IN	Consistent with Subquery NOT IN	select * from t1 where a1 not in (2,5,6);	a1 ---- 1 3 (2 rows)
ANY/SOME	If at least one comparison result is TRUE, it returns TRUE; otherwise, it returns FALSE	select * from t1 where a1 < any(array[1,3]);	a1 ---- 2 1 (2 rows)
ALL	If all comparison results are TRUE, it returns TRUE; otherwise, it returns FALSE	select * from t1 where a1 < ALL(array[3]);	a1 ---- 2 1 (2 rows)