Home › Forums › KX Academy › Scan vs Over KX Academy Scan vs Over Posted by roger on May 4, 2024 at 3:40 am Why is over giving us a single line of results while over will give many lines of results? Thank you. pgyorok replied 7 months, 3 weeks ago 2 Members · 1 Reply 1 Reply pgyorok Member May 6, 2024 at 9:16 am This is the standard behavior. Over only returns the last element, while scan returns the result after each step in the computation. Accumulators – Reference – kdb+ and q documentation – Kdb+ and q documentation (kx.com) Log In to Reply Log in to reply. Public All Members Only Me PublicAll MembersOnly Me Public All Members Only Me Log In to Reply Start of Discussion 0 of 0 replies June 2018 Now