My wishlist for SQL: the UNTIL clause
Posted in Databases on Jan 22, 2010
I’d like an UNTIL clause, please. I’d use it sort of like LIMIT in MySQL and PostgreSQL, except that it would define when to stop
returning looking for rows, instead of defining how many to return. Example:
SELECT * FROM users ORDER BY user_id UNTIL user_id >= 100;
That would select users up to and including user 99. Ideally the clause could accept any boolean predicate, including subqueries. I’ll hold my breath and wait for this wish to come true now.