How to exclude first row in SQL Server 2005 Express

Question

I want to exclude the first row from displaying from a SQL Server 2005 Express database... how do I do this?

I know how to return just the top row, but how do I return all rows, except the top row

score 5 · Answer 1 · answered Aug 10 '11 at 19:52

5

SELECT *
FROM yourTable 
WHERE id NOT IN (
         SELECT TOP 1 id 
         FROM yourTable 
         ORDER BY yourOrderColumn)

answered Aug 10 '11 at 19:52

Jacob

41,721
6
79
81

score 2 · Answer 2 · answered Aug 10 '11 at 19:53

2

SELECT *
    FROM SomeTable
    WHERE id <> (SELECT MIN(id) FROM SomeTable)
    ORDER BY id

answered Aug 10 '11 at 19:53

Joe Stefanelli

132,803
19
237
235

Would the anonymous downvoter care to explain their objection? – Joe Stefanelli Aug 10 '11 at 21:06

Brian Webster · Answer 3 · 2011-08-10T21:00:27.487

2

select * from 
    (select ROW_NUMBER() over (order by productid) as RowNum, * from products) as A
where A.RowNum > 1

edited Aug 10 '11 at 21:00

answered Aug 10 '11 at 19:53

Brian Webster

30,033
48
152
225

1

Wouldn't that just return `A.RowNum` values instead of rows from the original table? – Joe Stefanelli Aug 10 '11 at 19:55
This was a simplified example. Edited to be more clear by adding * to subquery. Better? – Brian Webster Aug 10 '11 at 21:00

score 1 · Answer 4 · answered Aug 10 '11 at 19:57

When you say you don't want the top row I assume you have some kind of order by that defines which row is at the top. This sample uses the ID column to do that.

declare @T table(ID int, Col1 varchar(10))

insert into @T
select 1, 'Row 1' union all
select 2, 'Row 2' union all
select 3, 'Row 3'

select ID
from @T
where ID <> (select min(ID)
             from @T)
order by ID

How to exclude first row in SQL Server 2005 Express

4 Answers4

Linked