KX Community

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

Home Forums kdb+ Error with sum Re: Error with sum

  • davidcrossey

    Member
    July 31, 2022 at 12:00 am

    Hi navdithya,

    Your query is selecting the value (.:) function by mid. You need to apply sum on a column by mid to get an aggregation e.g.

     

    show t:select sum column by mid from readings

     

    Kind regards,

    David