with cte as
(
select *, row_number() over (order by CustomerId) RowNumber
from Sales.Customer
)
select *
from cte
where RowNumber != 1
OR
select *
from
(
select *, row_number() over (order by CustomerId) RowNumber
from Sales.Customer
) tt
where RowNumber != 1
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…