【sqlServer】Order By 报错：The ORDER BY clause is invalid in views, inline functions, derived tables

--【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;