我知道我们可以在配置单元中使用大约Row_Number() OVER (partition by deptid ORDER BY rand() desc)
(假设我们想要在一些分区中随机获取一些行数据)进行一些随机采样.
但是,我不知道如何根据一个列值获取一些行.例如,我们希望获得一些按薪资加权的数据.如何做到这一点?
数据,如
create table employee (empid int ,deptid int ,salary decimal(10,2))
insert into employee values(1,10,5500.00)
insert into employee values(2,10,4500.00)
insert into employee values(3,20,1900.00)
insert into employee values(4,20,4800.00)
insert into employee values(5,40,6500.00)
insert into employee values(6,40,14500.00)
insert into employee values(7,40,44500.00)
insert into employee values(8,50,6500.00)
insert into employee values(9,50,7500.00)
有没有办法在蜂巢里做到这一点?