i****a
发帖数: 36252 | 1 basic idea is to use row_number and self joining tables. if you use CTE,
here is an example
with cte as
(
select ROW_NUMBER() over (order by tb1.colDate) as rn1, *
from tableTest2 tb1
)
select *
from cte
inner join (select ROW_NUMBER() over (order by colDate) as rn2, * from
tableTest2) tb2
on cte.rn1 = tb2.rn2 - 1 and cte.attr <> tb2.prev
if you don't want to use CTE or not on SQL server 2005 or later, then put
result from the 1st query into a temp table |
|
s*******k
发帖数: 252 | 2 哈哈哈真是自己瞎担心 微软其实蛮上路的
用Dell的DVD装了Win7，之后要求激活，在控制面板里把序列号改成主板机箱上的那串联网verify一下就通过了
网上查了一下，原来的主板生产商是ASUS IPILL-RN2，自己新换的一块也是Asus的corporate stable model，说不定是这个的缘故 |
|
|
|
|
h****y
发帖数: 4 | 6 I am going to take exam soon can you send to RN1and RN2(deleted content)to
x******[email protected]. thanks. |
|
