Retrieving only rows with nearest value (1 reply)
(MySQL.com) I have the following query:
SELECT threshold, premium, ind_limit FROM rates WHERE scheme_id=148 and threshold >=35000 and ind_limit>500000 group by premium_id order by threshold ASC, ind_limit ASC
...which generates a dataset as follows..
