and
Syntax
and(X, Y)
Arguments
X / Y is a scalar/pair/vector/matrix. If X or Y is a pair/vector/matrix, the other is a scalar or a pair/vector/matrix of the same size.
Details
Return the element-by-element logical X AND Y.
Examples
$ 1 && 3;
1
$ x=1 2 3
$ x && 0
[0,0,0]
$ x=1 2 3
$ y=0 1 0
$ x && y
[0,1,0]
$ t=table(1 2 2 3 as id, 4 5 6 5 as value)
$ t
id |
value |
|---|---|
1 |
4 |
2 |
5 |
2 |
6 |
3 |
5 |
$ select id, value from t where id=2 and value=5;
// SQL query
id |
value |
|---|---|
2 |
5 |