SQL语句

BeginTime  BtsId Total68PhyRCENum
2009-9-30 0:00 1 192
2009-10-1 0:00 1 192
2009-10-2 0:00 1 192
2009-10-3 0:00 1 192
2009-10-4 0:00 1 256
2009-10-5 0:00 1 256
2009-10-6 0:00 1 256
2009-10-7 0:00 1 256
2009-10-8 0:00 1 256
2009-10-9 0:00 1 256

如何根据Total68PhyRCENum发生变换后，替换出该条记录

---

BeginTime  BtsId Total68PhyRCENum
2009-9-30 0:00 1 192
2009-10-1 0:00 1 192
2009-10-2 0:00 1 192
2009-10-3 0:00 1 192
2009-10-4 0:00 1 256
2009-10-5 0:00 1 256
2009-10-6 0:00 1 256
2009-10-7 0:00 1 256
2009-10-8 0:00 1 256
2009-10-9 0:00 1 256

如何根据Total68PhyRCENum发生变换后，提取出红色这条记录

---

没看明白。

---

具体要求是啥？

---

--游标............
--  I love curssor......

---

我多加个S，呵呵，因为我喜欢它，..........

---

用个自增列,
再用子查询

---

SQL code:

select *,id=identity(int,1,1) into #t from tb1

select b.* from #t a,#t b

where a.id=b.id-1 and a.Total68PhyRCENum!=b.Total68PhyRCENum

---

select min(BeginTime) 
group by Total68PhyRCENum

---

2009-9-30 0:00 1 192
2009-10-1 0:00 1 192
2009-10-2 0:00 1 192
2009-10-3 0:00 1 192
2009-10-4 0:00 1 256