摘要:
先来个例子 SELECT YEAR(BirthDate), ROW_NUMBER() OVER(ORDER BY YEAR(BirthDate)) AS 'RowNumber',/* 按年产生一个唯一的序号 */ ROW_NUMBER() OVER(PARTITION BY YEAR(BirthDate) ORDER BY BirthDate) AS RowNumberPart... 阅读全文
posted @ 2007-07-17 11:38
方正
阅读(552)
评论(1)
推荐(1)
浙公网安备 33010602011771号