lyd882的博客

SQL分组统计经典问题统计每个组下TOP N的问题，例如统计每个学科前三名数据表sql(GreenPlum):create table tb_score(name varchar(20),subject varchar(20),score int)distributed by (subject);--数据插入表insert into tb_score(name,subject,score) values('john','math',80),('john','english',78),('