select * from tb A where not exists (select 1 from tb A.lat<lat) or not exists (select 1 fro tb A.lat>lat) or not exists (select 1 fro tb A.lng<lng) or not exists (select 1 fro tb A.lng>lng)select * from A where lat=(select max(lat) from tb) or lat=(select min(lat) from tb) or lng=(select max(lng) from tb) or lng=(select min(lng) from tb)
直接select max(lat),min(lat),max(lng),min(lng) from youtable;不行么
where not exists (select 1 from tb A.lat<lat)
or not exists (select 1 fro tb A.lat>lat)
or not exists (select 1 fro tb A.lng<lng)
or not exists (select 1 fro tb A.lng>lng)select * from A
where lat=(select max(lat) from tb)
or lat=(select min(lat) from tb)
or lng=(select max(lng) from tb)
or lng=(select min(lng) from tb)