https://stackoverflow.com/questions/30641876/monetdb-sql-method-to-locate-or-match-by-the-nearest-value-without-a-top-or-lim

i'm thinking i can do this with some costly self-join, but i'd appreciate any other eyes on the problem