char ** pt1和 char * pt2[] 的区别在哪?# Programming - 葵花宝典
k*g
1 楼
试过下面的,不行。第一个非Null的数据Ntile就是6,我一共有10000+数据
select *,
(CASE WHEN PB IS NOT NULL THEN NTILE(100) OVER(ORDER BY PB ASC) ELSE NULL
END) AS Rnk_PB6
into #temp6
from #temp5
select *,
(CASE WHEN PB IS NOT NULL THEN NTILE(100) OVER(ORDER BY PB ASC) ELSE NULL
END) AS Rnk_PB6
into #temp6
from #temp5