KX Community

Find answers, ask questions, and connect with our KX Community around the world.
KX Community Guidelines

Home Forums KX Academy Issues with Queries and qSQL Re: Issues with Queries and qSQL

  • rocuinneagain

    Member
    May 31, 2023 at 12:00 am

    1. There is no need for raze to be included.

     

    q)select type close by sym from daily
    sym | close 
    ----| ------ 
    AAPL| 9h 
    AIG | 9h 
    AMD | 9h ..

     

    Float vectors are being passed to your function (type 9h). raze has no effect on these.

     

    2. select size by sym from daily only does grouping as no aggregate function is included.

    It is the same as select {x} size by sym from daily

    Including a real aggregate would be select last5 size by sym from daily