摘要: select row_number() over(order by yw desc),* from score --有并列时也不重名 1.2.3.4....select rank() over(order by yw desc),* from score--有别列是调名 1.2.2.2.3.4.......... 阅读全文
posted @ 2011-09-21 17:51 ajunfly 阅读(399) 评论(0) 推荐(0)