SAS中文论坛

标题: 急：sas取数与oracle取数的区别 [打印本页]

作者: shiyiming 时间: 2010-10-21 09:02
标题: 急：sas取数与oracle取数的区别
select *
from
(
select rownum ro,a.*
from
(
select distinct slab_no from ocx.dtis01 where rownum<=5 ) a
)
where ro>=2

data b (keep=slab_no);
set ocx.dtis01 (firstobs=1 obs=5);
run;
sas中的结果和plsql的结果数值相同但是顺序不同；
哪位高手能给我个合理的解释!

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)