现在有一个比较复杂的where 条件,希望能够通过条件一张内存表分成符合条件的数据(tb2),不符合条件的数据[tb2] , 现在想到的方法是,先
tb1 = select * from tb where condition,
然后
delete from tb where conditiontb2 = select * from tb
但是这样的写法很难看,并且低效,请问是否有一种高效的方法来实现。
假设msg是内存表。
msg = table(1..10000 as id, take(`a`b`c,10000) as name) bcond = msg.id>6000 and msg.name ==`a t1 = msg[at(bcond)] t2 = msg[at(!bcond)]