SQL语句 问题

[兔子侠客]

查找表中的 前5条 和后5条数据

我是这么写的

select * from(

(select top 5* from table order by id)t

union
(select top 5* from table order by id DESC)a
)

在查询分析器里显示 有错误

请问应该怎么改啊
多谢！！

[six-years]

SELECT * FROM 
(select top 5 * from tests order by id )x
UNION ALL 
SELECT * FROM 
(select top 5 * from tests order by id desc)x

[dhy3610]

那个 5 和* 分开

[zhangsuyunpk521]

select * from(

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a
)

[hhzichen]

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a

[gua84607583]

with mytable as
(
    select top 5 * from table order by id
    union
    select top 5 * from table order by id DESC
)
select * from mytable 

[fjsnail]

select * from(

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a
) c

或者
(select top 5 * from table)t
union all
(select top 5 * from table order by id DESC)a

[lzk1018834925]

select * from(

(select top 5* from table order by id)t

union
(select top 5* from table order by id DESC)a
)
???
你这是？神马错误？
我记得
select top 5* from table
union
select top 5* from table order by id DESC
这样可以么？

[lzk1018834925]

[Quote=引用 6 楼 的回复:]

select * from(

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a
) c

或者
(select top 5 * from table)t
union all
(select top 5 * from table order by id ……
[/Quote]

顶一下

[Showwang2011]

[Quote=引用 1 楼 的回复:]

SQL code
SELECT * FROM
(select top 5 * from tests order by id )x
UNION ALL
SELECT * FROM
(select top 5 * from tests order by id desc)x
[/Quote]
我认为前五条那得by id 删掉有点多余，这样应该可以了。

[风一样的大叔]

select * from(

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a
)

[兔子侠客]

楼上的几乎全有问题 都是小问题
(select top 5 * from table order by id DESC)a
)

不能加括号的

[Quote=引用 11 楼 的回复:]

SQL code
select * from(

(select top 5 * from table)t

union all
(select top 5 * from table order by id DESC)a
)
[/Quote]

[xingxingbanyue]

select * from(
(select top 5 * from table)
union all
(select top 5 * from table order by id DESC)
) 

另外，1. 只能在union的最后一个子查询中使用order by；

2. union会过滤重复数据，union all则显示不会过滤

[xingxingbanyue]

select * from(
(select top 5 * from table)
union all
(select top 5 * from table order by id DESC)
) as T