--【sqlserver】报错
with tp as
(select id,end_date,gua_com
from testbzm order by end_date)
select * from tp
/*
--报错
消息 1033,级别 15,状态 1,第 3 行
The ORDER BY clause is invalid in views, inline functions, derived tables,
subqueries, and common table expressions, unless TOP or FOR XML is also specified.
*/
--------------------利用TOP绕过报错
with tp as
(select top 100 percent /*返回符合条件的100%的记录,即所有符合条件的记录*/
id,end_date,gua_com
from testbzm order by end_date)
select * from tp
--另:【ORACLE】不报错
insert into testbzm values(1,'aa');
insert into testbzm values(2,'bb');
insert into testbzm values(3,'cc');
insert into testbzm values(4,'dd');
commit;
select * from testbzm;
--------
with tp as (
select i,v from testbzm order by v
)
select * from tp;
【sqlServer】Order By 报错:The ORDER BY clause is invalid in views, inline functions, derived tables
最新推荐文章于 2025-03-03 10:52:57 发布
