Does the DolphinDB language support not in syntax?

Question

Suppose I have the following table,

t=table(1..5 as id,6..10 as v)

I want to select the records from the table where id != 2 and id !=4 ,but I execute the following code ,

select * from t where  id  not in (2,4)

The error message is as follows,

Function not is not a binary operator

Does the DolphinDB language support not in syntax?

. . I would say that your error message is a pretty clear indication that DolphinDB does NOT support `NOT IN`. — Gordon Linoff, Feb 09 '20 at 13:57

score 1 · Answer 1 · answered Feb 19 '20 at 16:34

1

DolphinDB doesn't support the operator not in. But you can use two operators not and into solve your problem.

select * from t where not id in (2,4)

answered Feb 19 '20 at 16:34

Davis Zhou

1 Answers1