SQL Server selecting the Row of table Except the First one

tktrz96b 于 2023-06-04 发布在其他

关注(0)|答案(4)|浏览(166)

i want to select all the row except the Top One so can anybody help me on this Query.

4条答案

with cte as
(
    select *, row_number() over (order by CustomerId) RowNumber
    from Sales.Customer
)
select *
from cte
where RowNumber != 1

select *
from
(
    select *, row_number() over (order by CustomerId) RowNumber
    from Sales.Customer
) tt
where RowNumber != 1

In SQL Server 2012, you can do this:

select * from TableName order by Id offset 1 rows

SELECT * FROM table1
EXCEPT SELECT TOP 1 * FROM table1

If id attribute is known than we can use..

SELECT t1.* FROM table t1 LEFT JOIN (
  SELECT id
  FROM table 
  LIMIT 1
) t2 ON t1.id = t2.id
WHERE t2.id IS NULL;