selecting the Row of table Except the First one

Question

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

How's the "top one" defined - actually, which query???? – Will A May 17 '11 at 06:37 — Will A, May 17 '11 at 06:37

Alex Aza · Accepted Answer · 2013-06-19T22:46:44.357

10

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

edited Jun 19 '13 at 22:46

answered May 17 '11 at 06:40

Alex Aza

**with cte as ( select *, row_number() over (order by loan_issue_id) RowNumber from dbo.loan_issue_mcg ) select * from cte where RowNumber != 1 and loan_id=1170 ** this one still shows all the row – Dinup Kandel May 17 '11 at 07:00
@Dinup kandel - add `where loan_id=1170` inside of `cte` – Alex Aza May 17 '11 at 07:05
@Dinup kandel - with cte as ( select *, row_number() over (order by loan_issue_id) RowNumber from dbo.loan_issue_mcg where loan_id=1170) select * from cte where RowNumber != 1 – Alex Aza May 17 '11 at 07:06

score 6 · Answer 2 · answered Apr 24 '18 at 15:11

6

In SQL Server 2012, you can do this:

select * from TableName order by Id offset 1 rows

answered Apr 24 '18 at 15:11

david

score 1 · Answer 3 · answered Apr 17 '14 at 12:36

1

SELECT * FROM table1
EXCEPT SELECT TOP 1 * FROM table1

answered Apr 17 '14 at 12:36

kravits88

3 Answers3