• kdb+

  differ by in qsql

  Posted by kdb_newbie on June 23, 2024 at 10:21 am

  can I have an example of using differ in a qsql please!
  I want to only output rows where the rows in the table differ on one column but by each sym?

  megan_mcp replied 4 months, 3 weeks ago 3 Members · 2 Replies

  • qsql
• 2 Replies

• 

  unterrainer_ale

  Member

  June 27, 2024 at 4:00 pm

  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

  Administrator

  June 28, 2024 at 12:36 pm

  Hi @kdb_newbie

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

  Thank you @unterrainer_ale for providing an example.

  Thanks,

  Megan

Log In to Reply