摘要: select * from ( select f.VA_YYYY||'年名次' va_yyyy, f.COMPANY_NAME ,row_number() over(partition by f.VA_YYYY order by cast(score as decimal(10,3)) desc ) 阅读全文
posted @ 2019-12-18 15:10 renzy194 阅读(440) 评论(0) 推荐(0) 编辑