OR 运算符的 KDB 查询

Question

KDB Web 中的等效查询是什么:

SELECT * FROM TABLE
WHERE (COLA = 'A' AND COLB = 'B') OR (COLA = 'C' AND COLB = 'D')

http://kdbserver:5001/?select fro table where _____________________

注意:cola 和 colb 具有字符串数据类型

Answer 1

你可以做:

select from table where ((COLA like "string1")&(COLB like "string2"))|((COLA like "string3")&(COLB like "string4"))