数据库学习:在视图中用order by
敬业的IT人
互联网
佚名
2008-1-8 16:15:42
大家知道
1：如下查询语句没问题
select * from sysobjects order by name
2：如果把该查询语句建成视图
create view v_test
as
select * from sysobjects order by name
会提示出错:
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
3: 既然提示除非在语句中使用top 才能用order by，那就好说了
create view v_test
as
select top 100 percent * from sysobjects order by name
一切正常
再用select * from v_test查一下，确实已经正确排序。
1：如下查询语句没问题
select * from sysobjects order by name
2：如果把该查询语句建成视图
create view v_test
as
select * from sysobjects order by name
会提示出错:
The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
3: 既然提示除非在语句中使用top 才能用order by，那就好说了
create view v_test
as
select top 100 percent * from sysobjects order by name
一切正常
再用select * from v_test查一下，确实已经正确排序。
- 最新文章
- 用interbase做数据库[01-08]
- WebSphere数据库更新技巧二则[01-08]
- 对Spfile之参数错误修改的解决办法[01-08]
- 数据库基础学习:并发问题详述[01-08]
- 数据库中几个表之间的关联查询[01-08]
- 解决VFP的表格控件Grid变白等问题[01-08]
- 相关文章
- 用interbase做数据库[01-08]
- WebSphere数据库更新技巧二则[01-08]
- 数据库基础学习:并发问题详述[01-08]
- 数据库中几个表之间的关联查询[01-08]
- 数据库设计经验谈[01-08]
- 数据库设计经验谈 (2)[01-08]
