摘要：
create column table .t1 ( id int primary key, customer varchar(5), year int, product varchar(5), sales int ); insert into t1 values(1, 'C1', 2009, 'P1 阅读全文
摘要：
rank函数问题：表：employee 找出表中不同departmenid里salary最高的人员信息，筛选结果如下 解法：select name,salary,departmentid from ( select rank() over(partition by departmentid orde 阅读全文