SQLServer ntile獲取每組前10%的數據

比如獲取每個表的前10%個字段。
代碼如下：

select id , name , colid , rn from (
select * , rn = ntile (10 )
over (partition by id order by colorder )
from syscolumns )t where rn = 1