1.如果你说的是创建视图,只有同时使用top或for xml才可以用order by
例如:create view vv as select top 100 * from products order by product_id,是允许的
但是create view vv as select * from products order by product_id,就会出错
2.如果你说的是查询视图,可以随时用order by
例如:select * from vv order by product_id
温馨提示:答案为网友推荐,仅供参考