求个SQL语句，不要选择集合的第一条记录。

[JGH8041]

求个SQL语句，不要选择集合的第一条记录。

[中国风]

?
05 row_number()over(order by ID)生成序号不显示第一条
2005:
select *
from
(
select *,row=row_number()over(order by ID) from t)tmp
where
row>1

[benbenkui]

select top(n-1) * from tb order by col desc

[benbenkui]

先对索引列降序排列，再取前面的所有记录

[-狙击手-]

create table ta(id int,[name] char(4),type char(1) ,[money] numeric(12,2)) 
insert ta select 1,'aa','A',120
insert ta select 2,'ab','B',130
insert ta select 3,'ac','C',140
insert ta select 4,'ac','C',130
insert ta select 5,'ac','C',120
go


select * 
from ta a
where id <> (select min(id) from ta )
drop  table ta
/*

id          name type money          
----------- ---- ---- -------------- 
2           ab   B    130.00
3           ac   C    140.00
4           ac   C    130.00
5           ac   C    120.00

（所影响的行数为 4 行）
*/

[dawugui]

这是啥意思?

select * from tb where id not in (select top 1 id from tb)

[arrow_gx]

真的搞不懂LZ的意思，孩子是不要第一条吗？ 有什么条件呢，没有的话，有N多写法，下面几句都可以

select * from tb where id <max(id) order by id desc

select * from tb where id >min(id) order by id 

select * from tb where id not in (select min(id) from tb) order by id

select * from tb where id not in (select max(id) from tb) order by id desc

[JL99000]

愁人啊