612. 平面上的最近距离链接描述
【同distinct一样,where也可以多参数同时计较】
WHERE (a.x,a.y) <>(b.x,b.y)
【abs—>绝对值
power—>几次米 power(2,3) ==8
sqrt—>开平方】
# Write your MySQL query statement below
select round(min(sqrt(power(a.x-b.x,2)+power(a.y-b.y,2))),2) shortest
from Point2D a,Point2D b
WHERE (a.x,a.y) <>(b.x,b.y)
# Write your MySQL query statement below
select min(abs(A.x-B.x)) shortest
from point A ,point B
where A.x <> B.x
# Write your MySQL query statement below
select followee follower,count(follower) num
from follow
where followee in(
#先找到关注者
select distinct follower
from follow
)
group by followee
order by follower