sql的一道题求大神看看哪里有语法错误

select id, name, score from
(select g.id as id, l.name as name , g.score as score, dense_rank() over(partition by grade g order by score DESC) as rank 
from grade g
join
language l
on g.language_id = l.id) t
where rank <= 2
order by name, score, id 

 

查看全部
weixin_43566219
王艺宸
2021/01/14 02:00
  • mysql
  • sql
  • 点赞
  • 收藏
  • 回答
    私信

1个回复