Question

急求大神一句简单sql语句 写了一下午代码 有点乱 想不出来

歌曲表song(song_id, singer_id,playtime)假设只有歌曲id 歌手id 和播放次数三个属性
求：按照歌曲的playtime排列歌手（不是排列歌曲，一个歌手对应多首歌。。）

Answer 1

select singer_name from singer left join song on singer.id=song.singer_id order by playtime desc

按时间降序排列歌手。试试吧

Answer 2

select * from
(select singer_id,sum(playtime) as alltime from song group by singer_id)
order by alltime

Answer 3

SELECT
sum(playtime) as times,
singer_id
FROM
song
GROUP BY
singer_id
ORDER BY
times desc

Answer 4

select distinct songer_id from song order by playtime desc