I think your post is missing something important -- what operations exactly do you need to perform on the dataset?
Are you trying to get all of the values in a certain range? Get statistics on low and high in particular ranges? Look up a high for a corresponding low?
I'm looking up rows that match the range the columns provide. The first column is lower end of a range, the second column is higher end of a range. When a request comes in, it will try to match which range it belongs to and return that data
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
I think your post is missing something important -- what operations exactly do you need to perform on the dataset?
Are you trying to get all of the values in a certain range? Get statistics on
low
andhigh
in particular ranges? Look up ahigh
for a correspondinglow
?Ah, should have explained it better. Think that the data is
low,high,country
0,9,France
10,19,UK
20,29,Ireland
So if a request is made of 9 the corresponding row would be returned i.e 0,9,France
So, you are looking up rows that match exactly in the second column?
I'm looking up rows that match the range the columns provide. The first column is lower end of a range, the second column is higher end of a range. When a request comes in, it will try to match which range it belongs to and return that data