Home › Forums › kdb+ › differ by in qsql › Reply To: differ by in qsql
-
Hi,
I believe this is what you are looking for.
q)t:([] sym:`a`a`a`b`b`c`c`a`b`c;price:1 1 2 3 4 5 5 8 9 7) q)t sym price --------- a 1 a 1 a 2 b 3 b 4 c 5 c 5 a 8 b 9 c 7 q)select from t where (differ;price) fby sym sym price --------- a 1 a 2 b 3 b 4 c 5 a 8 b 9 c 7
You can read more about fby here fby – Reference – kdb+ and q documentation – kdb+ and q documentation (kx.com)