Comparison operatorsΒΆ

dual(11)                                //use dual() generator as the data source, generate 11 rows
.select(i)                              //select the integer field
.select(*, i = 5         as c_eq)       //select all fields from the previous and the equal comparison
.select(*, i != 5        as c_notEq)
.select(*, i > 5         as c_gt)
.select(*, i >= 5        as c_get)
.select(*, i < 5         as c_lt)
.select(*, i <= 5        as c_let)
.select(*, i is null     as c_isNull)
.select(*, i is not null as c_isNotNull)
i c_eq c_notEq c_gt c_get c_lt c_let c_isNull c_isNotNull
0 false true false false true true false true
1 false true false false true true false true
2 false true false false true true false true
3 false true false false true true false true
4 false true false false true true false true
5 true false false true false true false true
6 false true true true false false false true
7 false true true true false false false true
8 false true true true false false false true
9 false true true true false false false true
10 false true true true false false false true
11 false true true true false false false true