i want to select all the row except the Top One so can anybody help me on this Query.
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
548k questions
547k answers
4 comments
86.3k users