我想从一个SQL Server 2005前preSS数据库...排除显示的第一行是如何做到这一点？

我知道如何只返回排在前列，但我怎么回的所有行，除了最上面一行

  SELECT *
从yourTable
WHERE ID NOT IN（
         SELECT TOP 1号
         从yourTable
         ORDER BY yourOrderColumn）
 

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

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