摘要:在sqlserver中可以这样显示分组前N个成员, 关键在row_number, partitionselect * from (select schoolmember_id, row_number() over(partition by school_id order by schoolmember_id ) as number from schoolmember) as awhere a.number < 3 阅读全文
posted @ 2011-03-22 18:04 dragonpig 阅读(226) 评论(0) 推荐(0) 编辑