differ by in qsql

[unterrainer_ale]

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)

code.kx.com

kdb+ and q documentation

Documentation for kdb+ and the q programming language

[megan_mcp]

Hi @kdb_newbie

I have reformatted this question due to issues with our editor.

Thank you @unterrainer_ale for providing an example.

Thanks,

Megan