如何在 SQL Server 2005 Express 中排除第一行

发布于 2024-11-29 02:25:49 字数 94 浏览 1 评论 0原文

我想从 SQL Server 2005 Express 数据库中排除第一行的显示...我该如何执行此操作？

我知道如何仅返回顶行，但如何返回除顶行之外的所有行

原文

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

一刻暧昧 2024-12-06 02:25:49

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

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

回复收藏 0 原文

伏妖词 2024-12-06 02:25:49

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

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

回复收藏 0 原文

梦巷 2024-12-06 02:25:49

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

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

回复收藏 0 原文

枯叶蝶 2024-12-06 02:25:49

当您说您不想要顶行时，我假设您有某种 order by 来定义哪一行位于顶部。此示例使用 ID 列来执行此操作。

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

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

回复收藏 0 原文

~没有更多了~