内存,速度均超99% 题解 | #网易云音乐推荐(网易校招笔试真题)#
网易云音乐推荐(网易校招笔试真题)
http://www.nowcoder.com/practice/048ed413ac0e4cf4a774b906fc87e0e7
select music_name from( SELECT distinct music_name ,music_id FROM follow as f right join music_likes as m on f.follower_id = m.user_id join music on music.id = m.music_id where f.user_id = 1 and music_id not in (select music_id from music_likes where user_id =1 ) ORDER by music_id ) t order by music_id
CVTE公司福利 707人发布