【讨论】请教一个SQL语句的问题

Skye_to_Skye

select student_id,class_id,score from (
select a.student_id,a.class_id,a.score,
       dense_rank()over(partition by a.student_id order by a.score desc) rn
from my_test a) where rn =1

rc_hz

Skye_to_Skye 发表于 2015-1-6 16:35
select student_id,class_id,score from (
select a.student_id,a.class_id,a.score,
       dense_rank( ...

Postgresql似乎没有这样的语法。。。

kang389110772

这个数据库都不是oracle吧

xuhao167

1. select b.student_id,b.class_id from (select student_id,max(score) max_score from test.my_test group by student_id) a join test.my_test b on a.student_id=b.student_id and a.max_score=b.score;

复制代码