dolphindb查询重复值效率更高

Question

查某列不重复值,哪种占用内存少?或者有更合适的?
set(exec a from tb)
exec set(a) from tb

Answer 1

DolphinDB中distinct(X)函数返回向量 X 中不相同的元素:

exec distinct(a) from tb