| 问题：
table1------------------------------------f1 f2aa taa hbb hbb fbb fcc fcc fcc wcc rrr求结果如下 (sql 2000中）------------------------------------f1 f2 f3aa t 1aa h 2bb h 1bb f 2bb f 3cc f 1cc f 2cc w 3cc rrr 4
方法：用临时表实现如下：
select * ,IDENTITY(smallint, 1, 1) as Seq into Table1Tmp from Table1 order by f1
select a.f1,a.f2,b.Max-a.Seq+1 as f3 from Table1Tmp a,(select f1,Max(Seq)as Max,Min(Seq) as Min from Table1Tmp group by f1) b where a.f1=b.f1 order by a.f1,f3 |
