Re: Help with minimum/group by

[laptop alias]

Rick's solution should work. It may even be quick, and perhaps there's no good reason not to use it - but I don't know; relying on a quirk of the GROUP BY clause (that it hangs on to the 'first one' in the list) just doesn't seem right.

To my mind, this represents a purer (if somewhat old-fashioned) solution...

SELECT x.*
  FROM
     (
       SELECT *,ABS(b-14.3) dist FROM abc
     ) x
  LEFT 
  JOIN
     (
       SELECT *,ABS(b-14.3) dist FROM abc
     ) y 
    ON x.c = y.c
   AND x.dist > y.dist
 WHERE y.a IS NULL;