SELECT ST_DistanceSphere(ST_GeomFromText(‘%s’,4326),geom) AS distant FROM “lte小区工参geom” GROUP BY distant ORDER BY distant limit 1 offset 2
1是指且几行
2是指从第几行开始切
SELECT ST_DistanceSphere(ST_GeomFromText(‘%s’,4326),geom) AS distant FROM “lte小区工参geom” GROUP BY distant ORDER BY distant limit 1 offset 2
1是指且几行
2是指从第几行开始切