那比如刚好有两个分数位于界限上,且分数一模一样怎么办。只能取一个呢,取哪个呢
select * from tablename where fieldname not in
(
select top 10 percent fieldname from tablename order by fieldname union all
select top 10 percent fieldname from tablename order by fieldname desc
)
试试
select * from tablename where fieldname not in
(
select top 10 percent fieldname from tablename order by fieldname union all
select top 10 percent fieldname from tablename order by fieldname desc
)
试试
你的方法好像不行,我用了一下没能实现。我想可能应该用存储过程来实现。
1:寫個Function 得到某USER的平均得分
create FUNCTION getnum (@userid) return int as
.......
.....
retrun @s然後 select userid,dbo.getnum(userid) from uTable 2:存儲過程
將横列表轉換成縱列表(人名 ,分数類別,分数)
在作處理可能會好點
:(