Nearest neighbours (KNN) from a selected point
With a SELF JOIN, in the form of an inner join if you know the distance. Or a cross if you don't.

SELECT spatial_id, geom
FROM rhp_tvp.spatial AS rt1
JOIN rhp_tvp.spatial AS rt2
  USING ST_DWithin( rt1.geom, rt2.geom, MAX_DISTANCE )
WHERE rt1 ... -- SELECT POINT.
ORDER BY rt1.geom &lt;-&gt; rt2.geom
LIMIT 10


If you don't know the max distance of one point to another,

SELECT spatial_id, geom
FROM rhp_tvp.spatial AS rt1
CROSS JOIN rhp_tvp.spatial AS rt2
WHERE rt1 ..  -- SELECT POINT
ORDER BY rt1.geom &lt;-&gt; rt2.geom
LIMIT 10;