一个菜鸟的问题,怎么样才能在视图中使用order by ?

[snowerhuayun]

视图中为什么不能使用 order by 呢?
请问怎么解决?

[gmlxf]

-- 方法一：
create view v_a
as
select top 100 percent * from pubs..authors order by au_lname
go

select * from v_a

drop view v_a
go

-- 方法二：
create view v_a
as
select top 100 percent * from pubs..authors
go

select * from v_a order by au_lname

drop view v_a
go

[gmlxf]

除非同时指定了 TOP，否则 ORDER BY 子句在视图、内嵌函数、派生表和子查询中无效。

[gmlxf]

-- 方法二写错了，不需要用top了：
create view v_a
as
select * from pubs..authors
go

select * from v_a order by au_lname

drop view v_a
go

[sdhdy]

可以啊！

[zjcxc]

create view 视图名
as
select top 100 percent * from 表 order by 字段名

[pengdali]

create view 视图名
as
select top 9999999999999 percent * from 表 order by 字段名

[gmlxf]

楼上大力的有点问题
1、用top n percent中的n不能够大于100。


修正后如下：
select top 999999999 * from pubs..authors order by au_lname