Slide 10
Slide 10 text
GROUP BY / DISTINCT ͷ໎͍
͓ͱͳΔςʔϒϧఆٛ
$3&"5&5"#-&AVTFS@GSJFOEA
AJEACJHJOU
VOTJHOFE/05/6--
AVTFS@JEACJHJOU
VOTJHOFE/05/6--
AGSJFOE@JEACJHJOU
VOTJHOFE/05/6--
13*."3:,&: AJEA
6/*26&,&:AVTFS@JEA AVTFS@JEA
AGSJFOE@JEA
,&:AGSJFOE@JEA AGSJFOE@JEA
&/(*/&*OOP%#%&'"6-5$)"34&5VUGNC
SELECT friend_id
FROM user_friend
WHERE (user_id = '785595' OR
user_id = '3291611' OR.....)
GROUP BY friend_id
LIMIT 1000;
Γ͍ͨ͜ͱ
͋Δuserͷ෦ू߹͔Βॏෳͳ͠Ͱfriend_id͕1000݅΄͍͠
GROUP BYDISTINCT࣮ݱͰ͖Δ͜ͱಉ͡