-- p1 at (x1, y1) and p2 at (x2, y2), it is |x1 - x2| + |y1 - y2|
select round(abs(min(lat_n)-max(lat_n)) + abs(min(long_w)-max(long_w)),4)
from station'언어' 카테고리의 다른 글
| basic join: the report (medium) (0) | 2024.06.13 |
|---|---|
| median: percent_rank (0) | 2024.06.12 |
| 수입 1등은 몇 명인가 (0) | 2024.06.11 |
| round, ceil, floor, truncate (0) | 2024.06.11 |
| full outer join 불가능 (0) | 2024.06.10 |