查出一个表的前20条记录和后20条记录

[upeveryday]

查出一个表的前20条记录和后20条记录

[rivery]

--假如可确定顺序的列是col1
select top 20 * from tablename order by col1
select top 20 * from tablename order by col1 DESC

[lxzm1001]

select top 20 * from tablename

[zzxiaoma]

select top 20 *from table1 union all
select top 20 *from table1 desc

[the_secular_bird]

join 表名
id 主键名称


select * from [join] where [id] in ((select top 20 [id] from [join] order by ([id]))) or [id] in ((select top 20 [id] from [join] order by ([id]) desc))

[languang122]

select top 20 * from tablename order by 主键
union all --不删除重复行
select top 20 * from tablename order by 主键 DESC
这种方式我实验了一下,单独执行前一个select_statement 或后一个select_statement 没有问题
一加上union后为什么会提示union 附近有语法错误呢?

[fandy81]

the_secular_bird(最后的晚餐) 的语句比较可行！

[NOKIA_LIU]

呵呵。。the_secular_bird(最后的晚餐) 真是有心人。
楼主的意思是把前20条和后20天一起显示出来。。呵呵学习ing...

[zhangzs8896]

--假如可确定顺序的列是col1
select top 20 * from tablename order by col1
select top 20 * from tablename order by col1 desc

一起显示的话，union一下就可以了。

[云中客]

select top 20 * from tablename order by 主键
union
select top 20 * from tablename order by 主键 DESC
同意这个办法

[zhangyang555]

select id =identity(int,1,1),* into #t from table1
select top 20 * from #t --前20条
select top 20 * from #t order bu id desc --后20条

如果要一起显示:
select top 20 * from #t
union all --如果不允许重复记录就不要加all
select top 20 * from #t order bu id desc --后20条
drop table #t

[dbbbs]

select top 20 * from tablename order by 主键
union all --不删除重复行
select top 20 * from tablename order by 主键 DESC

[iwl]

select top 20 * from tablename order by 主键
union
select top 20 * from tablename order by 主键 DESC

[churchatp1]

如果你要排序的列是可以排序的可以这么做：
select top 20 * from tablename order by 列名
union all --不删除重复行
select top 20 * from tablename order by 列名 DESC
前提是要该列可以排序