How do I delete the nth row from a table?

Use delete and the virtual column i:

delete from `t where i = n

Don’t forget the backquote if you intend to delete-in-place.


This work is licensed under a Creative Commons License.
The views and opinions expressed herein are those of the authors and do not necessarily reflect those of any other person or legal entity.
Kdb+ is the registered trademark of Kx Systems, Inc.