2009年2月
同事教给偶的sql server 2005里的rank() over
摘要： 李家佳(李家佳) 12:18:37 select * from ( select username,SectionID,ExpertPoint, rank() over(partition by username order by ExpertPoint desc) tt from [UserSectionProfiles] where UserName in ('ghj1976','daisy... 阅读全文
posted @ 2009-02-13 12:22 new 维生素C.net() 阅读(684) 评论(0) 推荐(0)