« I know SQL and don’t care to learn q. Can I still get my work done while benefiting from kdb’s speed? | Main | What does it mean for a q function or table to be a ‘first class’ type? »

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.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
All HTML will be escaped. Textile formatting is allowed.