SQL select every xth row based on total number
|Added at||2016-12-29 12:12|
I have a table with gps data:
My queries select by a timestamp window:
The resultset becomes way to big for larger timespans and I want to limit the size of the resultset. However, I still want the data to cover the entire timespan, but with reduced resolution. So instead of
I want to select every n'th element based on my specified max resultset size and the actual size (count) of the data.
I want something like this