请在 下方输入 要搜索的题目:

有表 song(id,song_name,album,play_count,fav_count)分别表示歌曲的主键id、歌曲名、专辑名、播放次数和收藏次数,以下与order by相关的sql错误的是:


A、select * from song order by play_count asc;;
B、select * from song order by (play_count + fav_count) asc;;
C、select * from song order by fav_count desc where play_count > 5;;
D、select * from song order by id,play_count asc,fav_count desc;

发布时间:2025-05-21 17:31:39
推荐参考答案 ( 由 快搜搜题库 官方老师解答 )
联系客服
答案:select * from song order by fav_count desc where play_count > 5;
专业技术学习
专业技术学习
搜搜题库系统